This website stores cookies on your computer.
These cookies are used to improve your website
experience and provide more personalized services
to you, both on this website and through other media.
To find out more about the cookies we use, see our
Privacy Policy
Comments
Redgate Software
For example, a method that provides sys.dm_tran_locks joined to sys.dm_exec_sessions on request_session_id to session_id and left joins the sys.dm_exec_requests cross applied to the session_id's sys.dm_exec_sql_text(sql_handle) might help to provide some of the more serious information. Duration time is also important as is the tracking of job failures. It may all seem simple at the query level, but putting together something as comprehensive as was provided by SQL Monitor is not simple.
So, if there are suggestions, I'm all ears.
Thanks