Originally posted by rnealejr
Yes - sp4 is installed. Also, antivirus can cause several issues with any application. When you say jumping from 10% to 95%, are you isolating the application that is causing this ?
Thanks for the reply! Based on the Perf Monitor, sqlservr.exe uses up most of the CPU. VNC is what I am using to connect to it to monitor it remotely, which does take up some of the CPU. There are only a couple other programs that will take up 1 or 2 of the CPU, but that doesn't even seem worthy of mentioning.
There is only one database that is about 4.5 GB large. It is essentially an out of the box CRM system database, not custom built.
I have read an online resource for using Performance Monitor which was very helpful, but I haven't been able to determine what exactly SQL is doing to cause it to spike.
There are no jobs running while I am monitoring the performance. Memory doesn't seem to be a problem at all, and my indexes appear to be fine.
I would trash vnc and install terminal services (the administrative mode /not application) to remotely connect to your sql server machine. vnc causes cpu spikes. rtvscan is an antivirus application that causes spikes as well. When it hits 95% what applications are consuming the resource (is it only sql) ?