April 3, 2011 at 12:31 pm
Guys,
I am trying to understand how best we can monitor the mounted disks volume performance on windows 2008 / SQL 2008 clustered environement using perfmon.
Any assistance?
Regards
J
April 3, 2011 at 12:56 pm
Best place to start would be the WMI, counters provided within windows.
Have a root around.
There are loads of Physical Disk performance counters that can be used although they'll report the sum total (I think) of the activity rather than individual spindles.
There are also software applications that will keep a history for you (Nagios, zenoss, Hyperic) that can be used to spot trends.
---------------------------------------------
If data can screw you, it will; never assume the data are correct.
April 3, 2011 at 2:57 pm
Don't try to look at the disk stats directly, go with communication speeds. Non-dedicated spindles along with SAN cache's will mess with you.
What you'll want to monitor is avg disk sec/read, and logical disk: Disk read bytes/sec.
there's a few others but those will usually be your best benchmark indicators against a SAN. Once you've been SAN'd, you don't care as much (from a DB Admin side) about the actual physical spindles, you only care about how long it takes to get data and how much is getting pushed.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply