SQL Server Performance

lock analysis on database?

Discussion in 'Performance Tuning for DBAs' started by dba_boston, Jun 4, 2008.

  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
  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.

Share This Page