Idea Details

SQLServer Probe: Add Checkpoints

Last activity 06-24-2019 02:03 PM
Mark De Boer's profile image
02-06-2018 07:09 AM

It would be nice to have the ntperf sql counters also available as checkpoints in the sql server probe.

 

For some performance metrics, additional counters are needed like forwarded_records per sec, Lazy writes/sec, ... and these are only readable from ntperf probe.

 

Advantage of the sql probe is that it's usable as an agentless probe, plus it can connect to the cluster ip instead of the nodes, so only the active node gives data.

 

As it is now, the sql server probe is only usable in certain cases, where the provided checkpoints are sufficient.

 

best regards

Mark


Comments

02-27-2019 11:52 AM

Hello Mark, is there a reason for not using the ntperf or the remote perfmon probe to get those metrics?

02-06-2018 07:13 AM

And while they are there, add the AAG checkpoints into MCS.

And add the ability to add/use custom checkpoints in MCS