I recently bumped into this answer: http://ift.tt/1h7502D which suggests A DMV query to retrieve information regarding deadlock.
I'm planning to make this query a stored procedure and call it (using ADO.NET) in my .NET Application whenever it executes and use the output as a log of my application.
Do you think this set-up is ideal? Or would it cause performance overheads and what not to my application?
Note: I can't use SQL Profiler for my production environment so I'm planning to use this query inside my application.
Aucun commentaire:
Enregistrer un commentaire