How do you use cloud databases? Take the survey.
Options
SQL Monitor high number of SPIDs and CPU
jhosiene
Posts: 3 New member
Hi,
When we came into the office this morning we found one of our monitored servers (SQL 2005 Standard, running on Windows 2008) frequently hitting 100% CPU. We checked when this had started and it appeared to ramp up around 21:30 the previous evening. When we looked at current processes there were a number of SPIDs related to SQL Monitor running from around this time. They were all executing the following command (and had raised Long Running Query alerts in SQL monitor)
When we came into the office this morning we found one of our monitored servers (SQL 2005 Standard, running on Windows 2008) frequently hitting 100% CPU. We checked when this had started and it appeared to ramp up around 21:30 the previous evening. When we looked at current processes there were a number of SPIDs related to SQL Monitor running from around this time. They were all executing the following command (and had raised Long Running Query alerts in SQL monitor)
SQL PROCESS FRAGMENT
Process Full Command: xp_readerrorlog
Suspending monitoring on this server cured the problem and CPU dropped to normal levels (VM and SQL Monitor graphs below). We monitor another 3 servers and have never had this issue - so I suspect it is not a SQL Monitor problem but a problem with what is is trying to do with this server.
Has anyone seen this or similar issue previously?
Thanks,
Joe
Suspending monitoring on this server cured the problem and CPU dropped to normal levels (VM and SQL Monitor graphs below). We monitor another 3 servers and have never had this issue - so I suspect it is not a SQL Monitor problem but a problem with what is is trying to do with this server.
Has anyone seen this or similar issue previously?
Thanks,
Joe
Tagged:
Best Answer
-
Options
Russell D
Posts: 1,324 Diamond 5
This is a known issue with SQL Server, though why it would suddenly manifest recently I'm not entirely sure; did you just upgrade Monitor or patch the server?
Please see https://support.microsoft.com/en-us/help/973524/fix-the-execution-of-the-xp-readerrorlog-command-in-sql-server-2005-an for more information.Have you visited our Help Centre?
Answers
We only applied monitoring to that box yesterday so that is why it has only just cropped up.