Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLServerCentral Best Practices Clinic: Part 4 Expand / Collapse
Author
Message
Posted Saturday, June 04, 2011 10:13 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, January 10, 2014 7:20 AM
Points: 175, Visits: 723
Comments posted to this topic are about the item SQLServerCentral Best Practices Clinic: Part 4

Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com
Post #1119916
Posted Monday, June 06, 2011 9:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 13, 2013 2:41 PM
Points: 49, Visits: 42
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



Post #1120338
Posted Monday, June 06, 2011 9:41 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, January 10, 2014 7:20 AM
Points: 175, Visits: 723
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
http://www.sqlskills.com/BLOGS/PAUL/post/How-to-examine-IO-subsystem-latencies-from-within-SQL-Server.aspx



Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com
Post #1120353
Posted Monday, June 06, 2011 9:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 13, 2013 2:41 PM
Points: 49, Visits: 42
Great, thanks!
Patrick



Post #1120355
Posted Monday, June 06, 2011 11:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 9:26 AM
Points: 21, Visits: 25
Am I the only one who noticed that the write latency for TEMPDB was measured in *seconds*, not ms?

I would think 3.5 sec is a lot more worrisome than 3.5ms. Just sayin'.
Post #1120449
Posted Monday, June 06, 2011 11:26 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, January 10, 2014 7:20 AM
Points: 175, Visits: 723
Matt Guthrie (6/6/2011)
Am I the only one who noticed that the write latency for TEMPDB was measured in *seconds*, not ms?

I would think 3.5 sec is a lot more worrisome than 3.5ms. Just sayin'.


You must be, as I missed this, and so did the technical reviewer. Good catch! Next time I will pay more attention to the scale, instead of making assumptions, which is apparently what I did when I looked at the graph.

This definitely needs more in-depth analysis to see what is really going on during this maintenance window within tempdb. I have already planned to do a specific follow-up article on tempdb, and I will add this to my list to investigate.


Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com
Post #1120458
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse