Long Running Query Alert

OrionUK

What is the length of time a query has to run before the long running query alert is triggered?

Thanks.

Russell D

That depends entirely on how you have configured it. It's 10 minutes by default.

OrionUK

Thanks for the answer,  where do I configure it? I did have a look at the config file editor and loaded the Redgate.sqlmonitor.engine.alerting.base.service.exe.settings but I could not see where the value is to amend.

OrionUK

Forget my last question, I found it!

Russell D

You shouldn't need to edit anything in the config for Alert configurations, the config file controls the frequency of the samplers. Anything alert wise should be done through the UI.