Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Monitoring error Expand / Collapse
Author
Message
Posted Monday, March 11, 2013 2:47 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:44 PM
Points: 164, Visits: 484
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.
Post #1429481
Posted Tuesday, March 12, 2013 6:49 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, October 9, 2014 4:06 PM
Points: 450, Visits: 1,342
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
Post #1430171
Posted Thursday, March 28, 2013 8:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 19, 2013 8:38 AM
Points: 17, 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
Post #1436489
Posted Thursday, March 28, 2013 8:15 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:44 PM
Points: 164, Visits: 484
I've try that and I always seems to miss the window. Is there a way to look at the log some other way?
Post #1436492
Posted Thursday, March 28, 2013 8:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 19, 2013 8:38 AM
Points: 17, 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
Post #1436503
Posted Thursday, March 28, 2013 8:32 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:44 PM
Points: 164, Visits: 484
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.

Post #1436504
Posted Thursday, March 28, 2013 8:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 19, 2013 8:38 AM
Points: 17, 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
Post #1436535
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse