Waits are the delays caused when a process or worker thread cannot immediately access the resources it requires. Waits can be caused by either excessive activity or inadequate resources. Queues store incoming requests for resources that cannot be immediately satisfied.
Waits and queues can help to identify the resources which are under pressure.
But, I’m sure you already all know this, right?
What we’d like to know is – do you use waits and queues to analyze performance? If so, what specific information about waits and queues should SQL Response be giving you?
• Longest waits in last x hours e.g. top 10 waits in last 1 hour?
• Total wait time for each of these waits?
What overall performance metric for queues would be of most use to you?
As ever, let us know your thoughts.