Add additional Machine Metrics

GlasgowCeltic

Hi,

Is there a way to add additional machine metric e.g. any one of the non-sql perfmon counter? I can see there are some basic counters in the 'Machine Metrics' analysis but would like to add to this e.g. add additional network metrics

Adam W

Hi,

You can add additional custom metrics, as detailed here:
http://documentation.red-gate.com/display/SM4/Creating+custom+metrics+and+alerts

So for example, you can create or download custom network metrics, such as this one that gives an indication of how much time is spent waiting to send information over a network
http://sqlmonitormetrics.red-gate.com/os-wait-time-async_network_io/

I'm interested to know what metrics specifically would you find most useful to add?

Thanks,
Adam