Greg wrote: > Hello all, > > I'm taking a look at a Window's server that is running jbase 3.x. We > are having some intermittent performance issues and I'm trying to > figure out a few things. My background is in Universe on a Unix > system, so I'm searching quite a bit. > > I'm looking for a way to get data similar to the disk info returned by > sar in unix. Specifically the information about how many requests are > being made to the San at any given time. Basically I'm trying to > determine how many requests are being made at a given time. I do have > the ability to see queue depth on the disks, but have not found a way > to determine how many requests are being made. We share this San with > other applications/data bases, so I'm trying to determine if we are > causing the queue to build up, or if it is something else. > > Is there a way within jbase to determine how many read requests and > write requests are being generated by the DB at a given time? Is there > a way within Window's to tell this? > > Sorry for the vagueness of the question in advance, and thanks for > your responses. > > Greg > > --~--~---------~--~----~------------~-------~--~----~ > Please read the posting guidelines at: > http://groups.google.com/group/jBASE/web/Posting%20Guidelines > Greg,
When posting, you need to give us information about he operating system and the version of jBASE in question. Windows server with 3.x isn't really enough to go on. Please take a moment to read the article in the link above; it is only a few pages. So, firstly, I have never met a SAN that I didn't hate yet and when used with I windows, doubly so. I am pretty sure that you would be better off with a local RAID. That said though, if the SAN does not tell you where the queue saturations are coming from and you are sure that it is correctly configured, then your first port of call is: http://technet.microsoft.com/en-us/sysinternals/default.aspx Where you will find all the sysinternals tools, all of which are excellent. Beyond that, then you want performance monitoring software for windows that can use the perf counters. The standard perfmon in Windows will do at a pinch, in that it can measure the read and write perf counts fairly accurately, but you need to distinguish between requests made of the file system and physical IO requests of course. jBASE also has jprof, which will tell you things about the program as a whole. Finally, the biggest single wins you can get performance wise are to correct bad coding/algorithms in the application itself. This is where the jrpof program s will help you (though you might be about the first person on the planet to use them other than the authors ;). Start with those tools and see where you get to, Jim --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
