Options
Sqlmonitor Slow Response
goldmedal
Posts: 19
Hi Guys,
We are seemed to be experiencing slow response from sqlmonitor 3.0. Having investigated this issue it has come to our attention the culprit process is “RedGate.Response.Engine.Alerting.Base.Service.exe†which is causing the cpu utilization to fluctuate between 50-100%.
Things we have ruled out
1. No antivirus software on the server thus no sqlmonitor file scanning/intercepting.
2. Sqlmonitor tracing is switched off so that can’t be having any impact.
3. The repository database resides completely on a different server which has no sign of performance related issues.
4. No memory pressure as the memory utilization is 2GB out of 4GB
It is apparent from Windows resource monitor that there is a large number of handles associated with “RedGate.Response.Engine.Alerting.Base.Service.exe†(Approx 220) which may well be contributing towards the impact.
Server Spec
OS: Windows server 2008 R2 service pack 1 (64 bit)
Processor : AMD 2.0 GHz (2 processors)
Memory: 4GB
Your help will be much appreciated.
Thanx
We are seemed to be experiencing slow response from sqlmonitor 3.0. Having investigated this issue it has come to our attention the culprit process is “RedGate.Response.Engine.Alerting.Base.Service.exe†which is causing the cpu utilization to fluctuate between 50-100%.
Things we have ruled out
1. No antivirus software on the server thus no sqlmonitor file scanning/intercepting.
2. Sqlmonitor tracing is switched off so that can’t be having any impact.
3. The repository database resides completely on a different server which has no sign of performance related issues.
4. No memory pressure as the memory utilization is 2GB out of 4GB
It is apparent from Windows resource monitor that there is a large number of handles associated with “RedGate.Response.Engine.Alerting.Base.Service.exe†(Approx 220) which may well be contributing towards the impact.
Server Spec
OS: Windows server 2008 R2 service pack 1 (64 bit)
Processor : AMD 2.0 GHz (2 processors)
Memory: 4GB
Your help will be much appreciated.
Thanx
Comments
Thanks for your post. We have opened a support ticket to investigate your performance issue with SQL Monitor. We will be contacting you shortly.
Best Regards,
Steve
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378