1. dba_boston Member

   Is there a way to do some kind of lock (deadlock) analysis on databases? Somehting like number of lock during a period of time, etc...
   Thanks
   

   dba_boston, Jun 4, 2008

   #2
2. Greg Larsen New Member

   Use profiler to capture deadlock event to a trace file, load the trace file into SQL Server and then count the number of deadlock events per hour, day, or whatever period you want.
   

   Greg Larsen, Jun 4, 2008

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in