Comments
Sort by recent activity
Hi Kristofer
I think that the chances of it being the DELL software is very low although it's definitely worth trying.
It's probably worth restarting the remote registry service on the server to see if this helps.
We are adjusting these alerts in v2.3 so it might be just a case of disabling these alerts for problematic servers until we can get the new version out.
Regards
Chris / comments
Hi Kristofer
I think that the chances of it being the DELL software is very low although it's definitely worth trying.
It's probably worth restarting the remote registry service on the server to se...
KristoferW wrote:
What's causing this? I simply updated the SQL Monitor Software, nothing else..
The monitoring error alerts were added in v2.2 so in previous versions the errors would still likely have been happening but you weren't being informed of the fact.
We're currently investigating improving the alerts in v2.3 to make them less sensitive or maybe allow the user to configure the sensitivity in some manner.
If you wish to know what is causing the errors then you'll need to follow the "Show Log" link for the relevant server on the Monitored Servers page. This log only shows errors for the last 5 minutes so you have to be quick sorry.
If you find the alerts annoying and aren't seeing any benefit then it's possible to disable them in Configuration > Alert Settings.
Hope this helps
Chris / comments
KristoferW wrote:
What's causing this? I simply updated the SQL Monitor Software, nothing else..
The monitoring error alerts were added in v2.2 so in previous versions the errors would still l...
That translates to "The requested resource is in use" which suggests that some other application (or SQL Monitor perhaps) is using the registry key we're trying to access.
Have you any other monitoring software that could possibly be attempting to connect to this server? I'm thinking of something like Microsoft's SQLH2 which collects data using remote registry in the same way we do.
Also is it just one specific server or do all your servers have the issue?
Thanks
Chris / comments
That translates to "The requested resource is in use" which suggests that some other application (or SQL Monitor perhaps) is using the registry key we're trying to access.
Have you any other monito...
Hi
This has been raised internally (ref: SRP-2790). Hopefully it'll be fixed for a forthcoming release but no guarantees at the moment.
Regards
Chris / comments
Hi
This has been raised internally (ref: SRP-2790). Hopefully it'll be fixed for a forthcoming release but no guarantees at the moment.
Regards
Chris
Hi
This is very likely a limitation of the trace flag (1204) we currently set to obtain deadlock information from the sql server error log. We will be reviewing this for v3.0. http://www.red-gate.com/MessageBoard/vi ... hp?t=12886
Regards
Chris / comments
Hi
This is very likely a limitation of the trace flag (1204) we currently set to obtain deadlock information from the sql server error log. We will be reviewing this for v3.0.http://www.red-gate.co...
Thanks for the extra information. I've raised a bug report (reference SRP-3585) to investigate this. / comments
Thanks for the extra information. I've raised a bug report (reference SRP-3585) to investigate this.
We didn't as far as I know change anything in the 2.2 release that would affect data collection in this way. I'll do some specific testing with Windows 2008 R2 to see if I can reproduce the issue.
Quick question, the account that you use to connect to these 2 servers, is it the account running the base monitor service or do you specify a different one?
Regards
Chris / comments
We didn't as far as I know change anything in the 2.2 release that would affect data collection in this way. I'll do some specific testing with Windows 2008 R2 to see if I can reproduce the issue.
...
It might be a good idea to test the remote registry connection to that server using the steps documented on this page: http://www.red-gate.com/supportcenter/C ... 402836.htm
The monitoring alerts were introduced in version 2.2 so it's possible that there were intermittent errors previously but you were not informed of them.
Hope this helps
Chris / comments
It might be a good idea to test the remote registry connection to that server using the steps documented on this page:http://www.red-gate.com/supportcenter/C ... 402836.htm
The monitoring alerts we...
Are you only getting the monitoring stopped alerts for a single server or are they all having this issue?
Regards
Chris / comments
Are you only getting the monitoring stopped alerts for a single server or are they all having this issue?
Regards
Chris
Have you checked the Show Log page just after receiving a Monitoring Stopped alert? This should give some more details about what is actually causing monitoring to stop. There is a Show Log link for each server or instance on the Monitored Servers page. The log only displays the last 5 minutes so you have to be pretty quick but hopefully there will be a more specific description of the error.
Regards
Chris / comments
Have you checked the Show Log page just after receiving a Monitoring Stopped alert? This should give some more details about what is actually causing monitoring to stop. There is a Show Log link fo...