Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am trying to track down a sql issue with timeouts and am by no means a DBA, but i'm stuck with the job so i'll get it done.

I've been running a trace on just about everything i can think of related to IO and network connectivity. The only number that stands out as insanely large is the one on the 'Wait for the Worker' Cumulative wait time.

Can someone explain to me what this is and at what point i should be concerned at it's value. What I have in my trace right now is 4611686018427391ms cumulative wait time. That can't be good right?

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

That time may be fine. It's the cumulative wait time since the instance was last started. If it's been running for months that number would be fine.

Limit your trace to commands which take a long time to run. You can filter based on the duration (it's in miliseconds). Try starting with 10000 or so and see what comes up. Start with the execution plans for these queries and see what indexes are missing.

share|improve this answer
add comment

Also be sure to check the DMV stats dashboard from Codeplex (Microsoft recomands it), it can save you a lot of time when faced with finding resource consuming queryes on your server : http://www.codeplex.com/sqldmvstats

Alternativley you can check out the actual Dynamic Management Views like:

select * from sys.dm_db_index_usage_stats select * from sys.dm_db_missing_index_details

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.