Monitoring error

Question

Monitoring error

HildaJ

SSCarpal Tunnel

Points: 4516
More actions
March 11, 2013 at 2:47 pm

#275149

I'm using Red-Gate Monitor tool to help me in managing our SQL Server. I see very frequently these two messages: Monitoring error (SQL Server data collection) and Monitoring Error (host machine data collection). I know there could be almost an infinite number of reasons for these error but I was wondering how would it be best to try to find out the reasons why I'm getting notified on these. I looked at our existing backup jobs and schedule jobs as well as the logs to see if I can find a reason why this is happening. Any other ideas or a direction that I need to go to get more information on this it would be very appreciated.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Leo.Miller SSChampion Points: 13051 More actions · Answer 1

I'd go back to Red-Gate. There's an old article that implies this may be a result of timeouts between the monitoring app and the SQL Server that causes false alerts to be raised. You may need to adjust the interval before a delay waiting for a response from the server becomes an alert.

See this article http://www.red-gate.com/messageboard/viewtopic.php?t=13374

Cheers

Leo

Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.

priya.sinha SSC-Addicted Points: 497 More actions · Answer 2

Hi,

When you get these alerts and while they are still active, you can navigate to 'Configuration > Monitored servers' page, then click the 'Show log' button against the monitored entity. This should show you detail about what is failing. If you need any help with this then please email us at support@red-gate.com and add link to this forum in email.

Thanks,

Priya

SQL Monitor Project Manager

HildaJ SSCarpal Tunnel Points: 4516 More actions · Answer 3

I've try that and I always seems to miss the window. Is there a way to look at the log some other way?

priya.sinha SSC-Addicted Points: 497 More actions · Answer 4

Yes, you can always look at the log files directly by clicking on Configuration > About and then clicking on 'View Base Monitor log file'. Or alternatively, you can also log in to the machine where you have installed Base Monitor and navigate to this folder or equivalent: \ProgramData\Red Gate\Logs\SQL Monitor 3. Drop us a message if you have any question or if you need help in tracking down the issue.

Thanks,

Priya

HildaJ SSCarpal Tunnel Points: 4516 More actions · Answer 5

Thank you I will definitely do. Although it not may occurrences when this happens I'd like to know if there's anything else I need to look into. The worse any DBA can do is ignore this type of small details, later they will hunt you.

Thanks again.

priya.sinha SSC-Addicted Points: 497 More actions · Answer 6

Hi,

SQL Monitor uses different data colletion methods. When you get one of these alerts then it indicates that one of the data collection methods have failed. So depending on which particular data collection has failed, the next step should be to investigate why? Feel free to get in touch if you need any help.

Thanks,

Priya