High number of processes blocked in SQLServer

Back to Runbooks


This incident type involves a high number of processes being blocked in SQLServer. It may cause delays or errors in database operations and can impact the performance of the system.



Next Step

2. Check the memory usage of the SQLServer process.

3. Check the blocked processes in SQLServer.

4. Check the top queries that are causing the blocking.

5. Check the current state of the SQLServer.

6. Check the SQLServer error logs for any relevant messages.


Define input parameters

Check for inefficient queries

Kill any long-running or blocking processes manually or automatically using a script.

Check the database for inefficiencies in queries or indexes that could potentially cause blocking. Optimize the queries or add indexes to improve performance.

Learn more

Related Runbooks

Check out these related runbooks to help you debug and resolve similar issues.