April 13, 2010 at 12:36 am
Hello friends,
Well its that time of the year again and i'm creating a budget for the coming year and i was thinking i would like a third party tool to analyse the deadlocks on my servers. So i was hoping i could get some advice from the vast wealth of knowledge found in our community.
Cheers 🙂
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
April 13, 2010 at 8:11 am
I use Quest's Spotlight which can send alerts and capture history related to several metrics including deadlocks. However, you could also just add an additional server side trace to capture this information. Another option for monitoring blocking in general would be to monitor and save results against sys.dm_tran_locks.
Personally if all I cared about was deadlocks I would just create a server side trace in t-sql that runs all the time on all the server instances like the default trace does by default, and then just set up a job to read/save that information in a table in your dbm/dba/management database on your sql instance that you have already or will create.
Regards,
Toby
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply