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