Skip to main content

Statistics

Short Description

The server is calculating statistics to develop a query execution plan. If a thread is in this state for a long time, the server is probably disk-bound performing other work.

Detailed Description

The server is calculating statistics to develop a query execution plan. If a thread is in this state for a long time, the server is probably disk-bound performing other work.

How to reduce this wait

To identify the source of high disk loads:

  • look to see if backups are occurring in the production window
  • look to see if the number of users has suddenly increased from normal
  • look to see if the queries running have changed execution paths resulting in more data being examined

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.