Custom metric does not collect data

darshanshahdarshanshah Posts: 5
edited October 17, 2013 6:44AM in SQL Monitor Previous Versions
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?

Comments

  • 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
    Priya Sinha
    Project Manager
    Red Gate Software
  • 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.
  • Hi,

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

    Thanks,
    Priya
    Priya Sinha
    Project Manager
    Red Gate Software
Sign In or Register to comment.