I have a Windows 2003 Sever with 8 GB RAM running SQL server 2005 SP1. Out of the total memory, SQL is dedicated 6GB memory and 2GB is for the Operating System. Well since a last few days, i have noticed that some server started consuming more CPU then it should consume normally. I tried running many memory and processor related tests but nothing gave me any hint what is causing this steep rise of processor utilization. We had a planned downtime so i restarted the server and everything was fine then. I still don't understand what was actuallu wrong and what was causing it. I have a feeling that this rise in cpu utilization will be back again in a month or so... I'm not sure but i feel so. Can this be an issue due to continuous uptime of the server? We can have a downtime only once in three months... Help!
Bookmarks