XSP web service consuming 99% of CPU

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

XSP web service consuming 99% of CPU

Postby jeffgonnering » Tue Apr 26, 2011 3:50 pm

Every so often I cannot log into the SQL monitor web page and when I look on the server that is hosting the SQL Monitor 2 Web Service, the XSP2.exe process is consuming 99% of the CPU. I restart the service and it goes back down to under 5%. I'm the only one requesting a page, so why would the web service be pegged? I could understand if the base monitor was pegged, but not the web service. Any ideas? Thanks.
jeffgonnering
 
Posts: 19
Joined: Mon Jan 03, 2011 11:35 pm
Location: Neenah, WI, USA

Postby Brian Donahue » Wed Apr 27, 2011 3:20 pm

Hi Jeff,

There aren't any known issues I can find about this. Is there any pattern to this high CPU usage, and are there other performance issues on the system at the same time? For instance, a long disk queue (>5) or low memory condition can manifest as high CPU. You can get CPU and memory usage from Task manager and disk queue length from perfmon.

If it is actually something in the SQL Monitor code we can try attaching a debugger and dumping the application stacks at the point when things start looking bad. If it happens again, please let us know and we can set this up for you.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby jeffgonnering » Thu Apr 28, 2011 9:47 pm

I do not recognize any pattern. It has happened a handful of times since we have been using the product, which has been for a few months now. If it happens again, I will get you the metrics you mentioned. Thanks for your help.
jeffgonnering
 
Posts: 19
Joined: Mon Jan 03, 2011 11:35 pm
Location: Neenah, WI, USA

Postby jeffgonnering » Tue May 10, 2011 3:23 pm

the issue has occurred again this morning. I emailed the log files to Red Gate support.
jeffgonnering
 
Posts: 19
Joined: Mon Jan 03, 2011 11:35 pm
Location: Neenah, WI, USA

Postby wrighla » Tue Oct 23, 2012 2:51 pm

I am having the exact same symptoms here on our SQL Monitor server. Was a resolution ever determined?
wrighla
 
Posts: 3
Joined: Fri Apr 13, 2012 7:27 pm

Postby Brian Donahue » Tue Oct 23, 2012 4:23 pm

The only definite cause I was able to find was this one case where an external requester was DOSing the webserver. Some external IP was making many requests per second for phishing URLs. For example http://server/cgi-bin, http://server/phpbb, etc.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby wrighla » Tue May 28, 2013 1:53 pm

I have a new computer for SQL Monitor this year and just upgraded everything with Redgate to the current version and I'm still having this problem. When I stop the "SQL Monitor 3 Web Service", the cpu frees back up. When I turn the service back on, cpu usage is normal. Is there any way to investigate and keep this from happening?
wrighla
 
Posts: 3
Joined: Fri Apr 13, 2012 7:27 pm

Re:

Postby priyasinha » Mon Jun 03, 2013 9:37 am

wrighla wrote:I have a new computer for SQL Monitor this year and just upgraded everything with Redgate to the current version and I'm still having this problem. When I stop the "SQL Monitor 3 Web Service", the cpu frees back up. When I turn the service back on, cpu usage is normal. Is there any way to investigate and keep this from happening?


Hi,

I would suggest to email support@red-gate.com. Also, this forum is not actively monitored now. Please raise any issue in SQL Monitor 3 forum.

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby gboulais » Wed Jul 31, 2013 5:18 pm

Exact same error here.
gboulais
 
Posts: 1
Joined: Wed Jul 31, 2013 5:10 pm

Re:

Postby priyasinha » Thu Aug 01, 2013 9:50 am

gboulais wrote:Exact same error here.


Hi,

Please could you raise this issue with support@red-gate.com?

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 2 guests