XSP web service consuming 99% of CPU
jeffgonnering
Posts: 27
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.
Comments
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.
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
Project Manager
Red Gate Software
Hi,
Please could you raise this issue with support@red-gate.com?
Thanks,
Priya
Project Manager
Red Gate Software
In taks manager i could see that it was actually launching the .exe then crashing/closing repeatedly.
Looked at the event log and the message wasn't very helpful;
2014-11-24 21:05:50,963 [3] ERROR RedGate.Response.UI.Server.Service.XspService [(null)] - XSP exited, restarting XSP...
But then ran the web service .exe directly and could see a socket error... Double checked and some moron had configured IIS with a default website on port 80 (so when xsp2.exe was trying to open the port it was crashing. I changed the port and restarted the service and voila!
Hope that helps!
http://tickett.wordpress.com