currym (6/6/2011)
Brad,I appreciate your work! I do have a question though.
With respect to monitoring SAN activity via an OS source (perfmon/sysmon), a while back I was discouraged from relying on anything but expensive proprietary SAN software - likely by a vendor. As a government DBA managing a couple thousand SQL instances, I'm always trying to save your money. 🙂 If you have a moment, would you mind speaking or linking to that apparent misdirection?
Again, many thanks,
Patrick
Not all of the built-in IO-related performance monitor counters work well if SQL Server is using a SAN for data storage, although some of them do. Two articles that discuss this topic (and their are many more) include:
http://msdn.microsoft.com/en-us/library/cc966412.aspx
Brad M. McGehee
DBA