[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 726
  • Last Modified:

"Number of Deadlocks/sec" in sql2005 how to fix this ?


I checked in "Number of Deadlocks/sec" it show me counter increased to 1200, anyway I can reset this counter without restarting the server ? what I can do to make sure we have only 0 counter for this "Number of Deadlocks/sec"


SQLServer:Locks  Number of Deadlocks/sec  1200
0
motioneye
Asked:
motioneye
  • 3
3 Solutions
 
guveraCommented:
Hi motioneye,

 Is this link useful to you? Have i understand correctly from your question? If anything please let me know/

Thanks
0
 
Anthony PerkinsCommented:
>>what I can do to make sure we have only 0 counter for this "Number of Deadlocks/sec"<<
This is a code problem.  As soon as you have fixed that it should go down to 0.

0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now