Custom metric does not collect data

darshanshah

I have created one custom metric. Which is working properly for server A but not working for another server B.
Not getting any error for that . When I checked the data for server B and custom metric in Cluster_SqlServer_Database_Keys ,however no data found for server B. on this server before maintenance window was set. I have removed it still it is not working.
If I'm making new metric for server B then again it is not working.

I just got one monitoring alert.
Monitoring error (SQL Server data collection)

Can any body have any idea?

priyasinha

Hi,

Can you go to Configuration > Monitored servers page? Then click 'Show log' against this SQL Server to see the error message. Alternatively, you can also try 'Test metric collection' for this custom metric for this particular server.

Thanks,
Priya

darshanshah

Hi Priya,
there is no any error.

I observerd that If I change data collection frequency from 1 to 5 minutes than custom metric starts collecting data. and on analysis page it is showing data. but if I do reverse process then it is not working.

priyasinha

Hi,

Looks like it needs more investigation. Can you please get in touch with support at support@red-gate.com?

Thanks,
Priya