Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  calucalating Average latch wait time(ms)

Author  Topic  snivas Starting Member 9 Posts Posted - 2011-12-05 : 10:46:33 Hey all, One of my Nagios plugin calucalating "Average latch wait time(ms)" and it producing Nagative values.We verified the plugin "what it is doing". Plugin fetching two values from my Server by using below queries and giving an output which is nagative values. SELECT cntr_value FROM master.dbo.sysperfinfo WHERE counter_name = 'Average Latch Wait Time (ms)' AND object_name = 'SQLServer:Latches' SELECT cntr_value FROM master.dbo.sysperfinfo WHERE counter_name = 'Average Latch Wait Time Base' AND object_name = 'SQLServer:Latches' Is it ok having "Average Latch Wait Time (ms)" in Nagative and If I want calucalate 'Average Latch Wait Time (ms)' what is best methode or script ? some body help, it greate appreciate help. Thanks in advance Snivas