SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Monitoring error


Monitoring error

Author
Message
HildaJ
HildaJ
SSC-Addicted
SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)

Group: General Forum Members
Points: 489 Visits: 571
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.
Leo.Miller
Leo.Miller
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1060 Visits: 1525
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
priya.sinha
priya.sinha
SSC Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 Visits: 74
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
HildaJ
SSC-Addicted
SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)

Group: General Forum Members
Points: 489 Visits: 571
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
priya.sinha
SSC Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 Visits: 74
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
HildaJ
SSC-Addicted
SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)

Group: General Forum Members
Points: 489 Visits: 571
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
priya.sinha
SSC Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 Visits: 74
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search