November 26, 2013 at 7:37 am
Hello Masters,
I got a complaint from the customer that "Average wait time" is very high on one of instance of my SQL Server 2008 R2. I checked there is not blocking and total number of locks are less than 100.
How can I check the Average wait time for any instance ? What can I do to normalize it ?
November 26, 2013 at 7:58 am
Depends on what the waits are for. Average wait time by itself is useless, to even begin to start you need to know what waits and what the tool considers high.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 26, 2013 at 8:07 am
Thanks Gila monster,
I dont know for what they are asking about. But I have below statement from the monitoring agent.
"The average amount of wait time (milliseconds) for each lock request that resulted in a wait. Based on the DB engine counter, has identical values for all databases on a SQL instance. "
Is this average time is for locks ? If yes, How can I check the average wait time for locks ? Is there any query to check Average wait time for any instance ?
November 26, 2013 at 8:15 am
It says locks, so one would assume it has something to do with locks.
As I said above, the 'average wait time for an instance' is useless. You need to investigate, find out exactly what waits, what the tool considers high, then investigate causes.
https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Start with chapter 1.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply