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.
• Best exam simulation Microsoft mcitp download free trial.
• Get certified in first attempt download mcitp-database-administrator - MCITP Database Administrator simulation.
• Best exam simulation Microsoft mcitp-database-administrator-sql-server download free trial.
• Become Microsoft MCITP Database Administrator SQL Server 2005 certified.
• Pass MCITP Microsoft SQL Server in first attampt.
• Get certified in first attempt download mcp - MCP simulation.
• Pass MCSA 2000 to 2003 in first attampt.
• Pass Microsoft mcsa-to-mcse-2003 - MCSA to MCSE-2003
• Click here to get free mcse-2003 MCSE exam practice questions.
• Become Microsoft MCTS SQL Server 2005 certified.
• Get certified in first attempt download 70-431 - SQL Server 2005 Implementation simulation.
• 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?