Solved

SQL Server 2008 R2 - Wait time

Posted on 2011-03-08
5
876 Views
Last Modified: 2012-05-11
Hi !

My SQL Server is showing a 3000 ms wait time under the "Other" wait category,  88 ms under the "Network I/O" category and finally 1354 ms under the Latch category. All other ressources monitors are looking okay.

Should I be alarmed by this ? A lot of my users complaint that their transactions are taking longer than usual.

What is the "other" ressource wait is for ? Can I expend this to obtain more details and how do I troubleshoot this ?

Thank you for helping.

-M

0
Comment
Question by:Rubicon2009
  • 4
5 Comments
 
LVL 5

Expert Comment

by:ThakurVinay
ID: 35080019
first where you got this wait time?

check the sys.dm_os_waiting_task to troubleshoot the waits.

also check the lock and long running queries.

HTH
Vinay
0
 

Author Comment

by:Rubicon2009
ID: 35083973
I got the stats using the Activity Monitor from SQL Management Studio
0
 

Author Comment

by:Rubicon2009
ID: 35084563
How can I know which table is locked ?
0
 

Accepted Solution

by:
Rubicon2009 earned 0 total points
ID: 35483622
No quality answer here.
0
 

Author Closing Comment

by:Rubicon2009
ID: 35510853
No quality answer here
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question