Page History
...
A common cause to high response times is when sessions are being blocked. To fix this problem, go to the Sessions tab and select the Blocking view to see if any sessions are blocking. You can then select the session and click either Trace Session to see what queries the session is creating and to see what is causing the block, or Kill Session to stop it.
Tip |
---|
To enable alerting when this metric is outside its established baseline, click the Baseline Thresholds Enabled (as percentage of baseline) check box in the Alert Configuration window. |
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...