Click here to Skip to main content
15,881,882 members
Please Sign up or sign in to vote.
1.22/5 (2 votes)
In my ERP the deadlock occurs, so many times , due to which my 200 employes in my company was not able to do their work. I am 1.3 yr Dot Net Developer, i dont have so much knowledge about the SERVER and these problem but through Google i found some solution, but still i cant get any success.
i try this query to find how many deadlock in my database..

SELECT cntr_value AS NumOfDeadLocks
  FROM sys.dm_os_performance_counters
 WHERE object_name = 'SQLServer:Locks'
   AND counter_name = 'Number of Deadlocks/sec'
   AND instance_name = '_Total'

and the O/P is 350 deadlock in my database.

so plz tell me some solution.its very urgently frnd.
Posted
Updated 11-Dec-17 21:31pm
v2

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900