2 results found
30 votesDaniel Rothig responded
Custom metrics on sys.dm_io_virtual_file_stats are the best way to get this today
168 votesunder review · Daniel Rothig responded
currently under investigation
An error occurred while saving the comment
At the moment alert ‘Long-running query’ is being triggered on known long running processes. We can off course exclude them from that one rule but we want to be able to make a second configuration to cover the excluded processes. (They are allowed to run longer, not unlimited).
Examples of those processes are ‘BACKUP DATABASE’ or ‘xp_sqlmaint’. These are maintenance jobs, however the same will apply to our application which also have long running batches.