SQL Server 2008 R2 - Wait time
Posted on 2011-03-08
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.