What are waits?

Waits occur when worker threads are either waiting for a task to complete, or to be assigned to them. This can cause problem in the performance of the database. The SYS. DM_OS_WAIT_STATS stored procedure can be used to view the waits statistics and diagnose the performance problem.

Waits are of the following types:

• Resource wait: The resource wait occurs when a thread is waiting for such a resource that is not available. A resource may not be available because of being locked by some other thread.
• Queue wait: The queue wait occurs when a thread is idle and is waiting for a task to be assigned to it. It is related to the system background task such as cleanup task, deadlock monitor, etc.
• External wait. The external wait occurs when SQL Server thread is waiting for an external event to finish.

• Become Microsoft MCAD certified.
• Download practice question and study guide for mcitp for exam.
• Download free practice test for Microsoft MCITP Database Administrator exam.
• Click here to download mcitp-database-administrator-sql-server test study guide and practice question.
• Click here to get free mcitp-database-admin-sql-server-2005 MCITP Database Administrator SQL Server 2005 exam practice questions.
• Pass Microsoft mcitp-sql-server - MCITP Microsoft SQL Server
• Pass MCP in first attampt.
• Click here to download mcsa-2000-to-2003 test study guide and practice question.
• Download free practice test for Microsoft MCSA to MCSE-2003 exam.
• Best exam simulation Microsoft mcse-2003 download free trial.
• Click here to get free mcts-sql-server-2005 MCTS SQL Server 2005 exam practice questions.
• Pass SQL Server 2005 Implementation in first attampt.
• Become Microsoft SQL Server 2005 Optimizing and Maintaining certified.
• Pass Microsoft 70-447 - SQL Server 2005 Design

• Previous Entry: What is piecemeal restore?
• Next Entry: What is a database diagram?