Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2003-06-15 : 00:46:09
|
| Ok, I'm still in the process of a top-to-bottom performance evaluation. The big stuff seems to be good -- the app doesn't get any blocking or deadlock as far as I can tell, very very few SQL compiles, etc.However, DBCC sqlperf shows that "RESOURCE QUEUE" is the main cause of waits. Now, I realize that it's only normal to have some waiting going on. However, is there any way to drill down and see *what* resource the issue is?Select * from sysprocesses has helped me in the past, but as far as I can tell the lastwaittype is *never* RESOURCE_QUEUE. I can find locks and latches on tables and such, but no data on what resources are causing the waits.Anyone got any insight on this?Thanks-b |
|
|
|
|
|
RESOURCE_QUEUE ?