Comments
2 comments
-
I put SQL monitor back on the test server with this OS/SQL combo and within a few hours cpu hit 100% so proved this is the issue. -
Hi,
I recommend applying the cumulative updates from Microsoft, as we've had these solve similar issues in the past.
More on this here: https://support.microsoft.com/en-us/help/973524/fix-the-execution-of-the-xp-readerrorlog-command-in-sql-server-2005-and-in-sql-server-2008-stops-responding-and-the-usage-of-the-cpu-that-is-running-the-command-increases-to-100-percent.
I realise that you said its difficult to get systems patched but if you don't have the 'SQL Server 2008 Service Pack 1' Cumulative update 4 installed, it is worth trying to get it installed (https://support.microsoft.com/en-us/help/973602), or finding the appropriate cumulative update pack (based on your full SQL version) from here: https://support.microsoft.com/en-us/help/970365.
Add comment
Please sign in to leave a comment.
All are running Windows Server 2008R2 Standard or Enterprise Edition SP0 with SQL Server 2008 SP1 Standard edition.
Other servers running the OS with SP1 and SQL 2008 SP2, SP3 or SP4 are completely unaffected.
I'm also monitoring SQL2008R2, 2012 & 2014 on Windows 2008R2 SP1 and 2012R2 with no issues.
In the end we had to stop SQL Monitor services, reboot the SQL servers, start SQL Monitor again and then suspend the affected servers in SQL Monitor. Since then all has been ok so I've put this down to the OS/SQL combination being monitored.
I thought I should highlight this problem even though I suspect your answer is to apply the latest SP to Windows and SQL - I've been trying to get that done for a long time but have met the usual obstacles with legacy systems and risks.
Any advice or thoughts would be welcome.