InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 10:31:06 GMT20http://www.sqlservercentral.com/Forums/Topic1119916-1357-1.aspx[quote][b]Matt Guthrie (6/6/2011)[/b][hr]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'.[/quote]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.Mon, 06 Jun 2011 11:26:15 GMTbradmcgehee@hotmail.comhttp://www.sqlservercentral.com/Forums/Topic1119916-1357-1.aspxAm 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'.Mon, 06 Jun 2011 11:07:05 GMTMatt Guthriehttp://www.sqlservercentral.com/Forums/Topic1119916-1357-1.aspxGreat, thanks!PatrickMon, 06 Jun 2011 09:43:19 GMTcurrymhttp://www.sqlservercentral.com/Forums/Topic1119916-1357-1.aspx[quote][b]currym (6/6/2011)[/b][hr]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[/quote]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.aspxhttp://www.sqlskills.com/BLOGS/PAUL/post/How-to-examine-IO-subsystem-latencies-from-within-SQL-Server.aspxMon, 06 Jun 2011 09:41:03 GMTbradmcgehee@hotmail.comhttp://www.sqlservercentral.com/Forums/Topic1119916-1357-1.aspxBrad,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,PatrickMon, 06 Jun 2011 09:23:57 GMTcurrymhttp://www.sqlservercentral.com/Forums/Topic1119916-1357-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/ssc+clinic/74097/">SQLServerCentral Best Practices Clinic: Part 4</A>[/B]Sat, 04 Jun 2011 22:13:19 GMTbradmcgehee@hotmail.com