Can we set an Alert for Wait ms/s reaching a threshold

Toby

The dashboard shows a nice graph of Waits with a total ms/s.
We're capturing this information, so can we raise an alert when it reaches a threshold?

Russell D

You'd need to set up a custom metric to perform the collection and then work out your thresholds from there. http://sqlmonitormetrics.red-gate.com/os-wait-time-cxpacket/ might be a good starting point.

I'm afraid there is no way natively to do this though.

RichardL

Hi @Toby

Thanks for your post. 

Can you let me know which version you're on so that I can provide you with a link to the documentation on alerts for that one? 

Kind regards

Richard Lynch. 

Toby

Hi @RichardL

We're on 8.0.5.13568

Thanks

Toby

RichardL

Hi @Toby

Thanks for your reply and version number. 

The information on alerts for V8 is in the link below. 

https://documentation.red-gate.com/sm8/alerts

I hope this helps. 

Richard. 

Toby

Hi @RichardL

I'd previously read these, and have taken another look through, but I don't see anywhere or an example script of how to set an alert on Total Waits (ms/s).

If I've missed something, feel free to let me know.

Toby