jeudi 30 juillet 2015

Are SQL DMV Queries Ideal as Stored Procedure?

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