Deadlock

Rédigé par M Sozezzo - - Aucun commentaire

We have same SQL Scripts to try to find out about what it happens when we have or had deadlocks.

 

  • Get current running commands.
  • Create event to find blocked processes and deadlocks.

 

Sources :

Deadlocking
https://technet.microsoft.com/en-us/library/ms177433%28v=sql.105%29.aspx

How to isolate the current running commands in SQL Server
https://www.mssqltips.com/sqlservertip/1811/how-to-isolate-the-current-running-commands-in-sql-server/

How To Monitor Deadlocks in SQL Server
http://blogs.technet.com/b/mspfe/archive/2012/06/28/how_2d00_to_2d00_monitor_2d00_deadlocks_2d00_in_2d00_sql_2d00_server.aspx

A very quick guide to deadlock diagnosis in SQL Server
https://dzone.com/articles/very-quick-guide-deadlock

Finding Blocked Processes and Deadlocks using SQL Server Extended Events
http://www.brentozar.com/archive/2014/03/extended-events-doesnt-hard/#comments

 

Lire la suite de Deadlock

Fil RSS des articles de ce mot clé