CPU %, Avg. Disk Queue Length and Pages/Sec too high
Posted on 2006-11-29
I have a Windows Server 2003 service pack 1 with SQL 2000 server service pack 3 installed. I have all the latest Microsoft Updates for the OS, but I don't know if I do for SQL. It was working OK and then started to slow down. Now it is CRAWLING. Sql and an Access program take up all the space. Over the night, I have been watching and they have been both at around 30-40% usage (with nobody in the office). I loaded Server Performance Advisor but it would not run and it immediately sent the CPU % to 100. When I closed that program, the other two were still up at 30-40%. Sql was usually a lot higher (like 80-100%). I am running a full virus scan right now and it has the CPU, Avg. Disk Queue Length and Pages/Sec counters going crazy. The CPU is basically 100. The disk is defragged. It has a 150 GB disk and P4 1.80 GHz with 1 GB of RAM. The virus scanner just stopped and there aren't any virus's. ALso, the CPU % is now averaging 77 but the pages per sec is at 0. When I check the task manager though, it says that sqlserver is using 34% CPU and 650 MB RAM. The next two processes listed are VPC32 and Rtvscan using 31 and 26 MB RAM. Pbeagent is using 13 MB. Maybe this is a SQL question...is it using too much memory? If so, what would cause that? How can I fix it? Thank you so much for any answers!