Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
The Spotlight xp_readerrorlog procedure never completes and causes 100% CPU on SQL Server 2005
Description
Every morning at 3 AM Spotlight runs an XP_Readerror log stored procedure on a SQL Server 2005 instance. However, it appears to never complete and ends up running another xp_readerrorlog the next morning and the issue compounds. After 10 days of this scenario the CPU utilization on the server spikes at 100%.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.