March 15, 2005 at 6:19 pm
We are monitoring our SQL server with perfmon and one of the counter keeps consistently hight. The Average latch wait time (ms) is always at 1000 level, which means the average time it takes for a latch to be granted is about 1 second.
Anybody know why is this counter constantly hight? How can I lower this?
Thanks.
James
March 16, 2005 at 7:17 am
I don't think you need to worry about this unless your other counters are giving rise to concern. It's not a counter i monitor.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
March 17, 2005 at 1:21 pm
...Latches are short term light weight synchronization objects. Latches are not held for the duration of a transaction. If high, check PERFMON for memory pressure, disk bottlenecks. Did you perfrom benchmarking? You might want to write a query which will insert the result of Perfmon counters into the table, which you can analyze later.
March 17, 2005 at 1:24 pm
How can I write a query which will insert the result of Perfmon counters into a table?
Thanks.
March 18, 2005 at 10:40 am
well, basically output the counter you want to monitor to a CSV file format.
Later files can then be imported into database PerfmonCounterLogs using DTS, for further analysis.You might want to do that on separate servers.
March 18, 2005 at 11:23 pm
You can also get the SQL Server Perf Monitor counters from within SQL Server from the table sysperfinfo.
Check out BOL or execute
select * from sysperfinfo
where object_name = 'SQLServer:Latches'
to get latch information.
Scott Thornburg
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply