Red Gate forums :: View topic - Sqlmonitor Slow Response
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Sqlmonitor Slow Response

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
goldmedal



Joined: 18 Mar 2009
Posts: 12
Location: Preston

PostPosted: Wed Sep 12, 2012 11:24 am    Post subject: Sqlmonitor Slow Response Reply with quote

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
Back to top
View user's profile Send private message
stanori



Joined: 23 Apr 2012
Posts: 84

PostPosted: Thu Sep 13, 2012 10:15 pm    Post subject: Reply with quote

Hi goldmedal,

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group