What are the frequently used wait types in SQL Server

The following are various commonly used wait types in SQL Server.

They are.

  1. LCK_M_IX
  2. LCK_M_X
  3. WRITELOG
  4. CXPACKET
  5. PAGELATCH_EX
  6. PAGEIOLATCH_SH
  7. ASYNC_NETWORK_IO
  8. SOS_SCHEDULER_YIELD
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s