Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Typically, this value should average below 2000 ms for a well tuned network and server. Average values in excess of 2000 ms indicate either an excessively busy network segment or a stressed SQL Server.

Reduce your SQL Server response time

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.

...