Need to monitor long running SQL transactions

If you haven't found a LogicModule for this already in the Exchange, start by asking the question: How would I detect this today manually? For SQL, there should be some sort of query you can execute to grab the current list of transactions with their time. The ephemeral nature of SQL transactions makes tracking this in a DS sort of difficult. You might think about a scripted EventSource that grabs the list of processes that are running and opens an alert for any items in the list that are very long.

Also: sorry, but you'll need to sign up and sign in to post the reply. Guests were inadvertently given the ability to post in the community, which is against our policy and has been rectified.