October 30, 2014 at 8:14 am
Hi all,
To preface this post, I'm well aware that what I'm asking for is probably not recommended, but this is somewhat of an emergency situation.
I know that in SQL Server 2008, the Resource Governor allows you to restrict the CPU utilisation for specific profiles. Is there something similar available in SQL Server 2005?
We have seemingly random times of the day where the CPU utilisation shoots up to 100%. I have no idea why it happens, and I can't pinpoint a specific time it happens either. I can't run the profiler to catch it, because I would need to have the profiler running 24/7, and even then, it might not happen for several days or weeks.
When the utilisation does go to 100%, it becomes impossible to connect to the server to monitor it, even using DAC. The only solutions are to either wait it out, or kill the process, and neither allows me to figure out what is going on.
What I'd like to do is force SQL Server to leave at least 5% CPU available, so that I can connect and view what's going on. Does anyone know of any SQL scripts or procedures that would allow me to do this?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply