| Author |
Message |
jeffgonnering
Joined: 03 Jan 2011
Posts: 15
Location: Neenah, WI, USA
|
 Posted: Tue Apr 26, 2011 3:50 pm Post subject: XSP web service consuming 99% of CPU |
 |
|
| 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. |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6348
Location: Red Gate Software
|
| Posted: Wed Apr 27, 2011 3:20 pm Post subject: |
|
|
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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
jeffgonnering
Joined: 03 Jan 2011
Posts: 15
Location: Neenah, WI, USA
|
| Posted: Thu Apr 28, 2011 9:47 pm Post subject: |
|
|
| 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. |
|
| Back to top |
|
|
jeffgonnering
Joined: 03 Jan 2011
Posts: 15
Location: Neenah, WI, USA
|
| Posted: Tue May 10, 2011 3:23 pm Post subject: |
|
|
| the issue has occurred again this morning. I emailed the log files to Red Gate support. |
|
| Back to top |
|
|
wrighla
Joined: 13 Apr 2012
Posts: 2
|
| Posted: Tue Oct 23, 2012 2:51 pm Post subject: |
|
|
| I am having the exact same symptoms here on our SQL Monitor server. Was a resolution ever determined? |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6348
Location: Red Gate Software
|
| Posted: Tue Oct 23, 2012 4:23 pm Post subject: |
|
|
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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
|
