Need to monitor long running SQL transactions
Need to monitor long running SQL transactions
we had one run long and take down tons.
LM User
Posted 5 years ago·Last reply 1 year ago
2 comments
Need to monitor long running SQL transactions
we had one run long and take down tons.
Jaidev Upadhya
·1 year agoI'm guessing we'll need to write a custom datapoint using either Groovy or PowerShell scripts to achieve this... Has anybody tried to do it?
LM User
OP5 years agoIf 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.