Solved

CPU %, Avg. Disk Queue Length and Pages/Sec too high

Posted on 2006-11-29
11
3,267 Views
Last Modified: 2007-12-19
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!
0
Comment
Question by:smalleysmalley
11 Comments
 
LVL 5

Expert Comment

by:MrNetic
ID: 18036205
smalleysmalley ,

Could you please post the values of averege disk queue lenght.

Best Regards,

Paulo Conde;a.
0
 
LVL 16

Accepted Solution

by:
AlexNek earned 125 total points
ID: 18036459
Rtvscan is part of Norton AntiVirus I think so you have online antiivirus control. Check settings for Antivirus control and try to diable it temporary for performance check. What is with HDisk activity? LOW /HIGH
0
 
LVL 13

Assisted Solution

by:stergium
stergium earned 125 total points
ID: 18038222
you server system hardware is ok if it is only used for the sql server.
my guess is same as alexnek . it should be the antivirus.
You can also check if there are any jobs in the sql agent (like backup jobs, checks and so on.). that could be a reason also.
hope that we gave you a hit of what is happening
0
 
LVL 2

Expert Comment

by:eric_bender
ID: 18041949
Rtvscan is Symantec/Norton's Real Time virus scan.  It runs on the local machine for all files coming in and out and on... You can control the "frequency" if you wish.... But I would be more apt to look at what MrNetic suggested.... also what is the % processor time and pages/sec counters from Perfmon.?
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 57

Expert Comment

by:giltjr
ID: 18042906
How many and how big are the the databases you have on this box?

What is the transaction rate?

What type of queries are you running?

Is this a new box/application?

Has it always run like this?

If a "old" box and application, did it just start doing this over night, or has it been slowly using more CPU and memory gradually.

SQL, along with all DBMS, likes to use as much RAM as possible.  It caches the index and data in memory to reduce the amount of real I/O it does as real I/O is much slower that cached I/O in RAM.
0
 
LVL 10

Expert Comment

by:Phadke_hemant
ID: 18043030
rtvscan runs if you have scheduled norton antivirus scan. if you don't want the daily scans to run, change the schedule otherwise remove the automatic/ administrative scan
0
 
LVL 76

Assisted Solution

by:arnold
arnold earned 125 total points
ID: 18046740
You should check the sql to see whether there are maintenance jobs setup.  It is very difficult based on the information you provided to suggest a course of action.  
Adding additional memory into the system will help since the sql server is now using 650MB out of 1GB.  Get the system to 3 or GB and you should see an improvement.  The slowness is because of the swapping.  How is the server configured for background or for applications (properties of my computer,advanced tab, performance button, advanced tab?  configuring it as an application server might also help if the server is currently configured for background.
0
 
LVL 2

Assisted Solution

by:eric_bender
eric_bender earned 125 total points
ID: 18046803
If your sure it is SQL you can also Limit the amount of Memory that SQL has available to it.  Using the Enterprise Manager is the easiest. Right click on the name of your SQL Server - > Properties.  Memory Tab and assign a fixed amount instead of Dynamic.  This would be an easy test before going out an buying more memory.  Just limit SQL to approx half of the installed memory.  Just a thought.

   -E-
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
health check servers 7 75
Issue to mail 11 39
SCCM And Branchcache Server 1 34
Anti-virus for Linux Server 15 85
I don't know if many of you have made the great mistake of using the Cisco Thin Client model with the management software VXC. If you have then you are probably more then familiar with the incredibly clunky interface, the numerous work arounds, and …
In a recent article here at Experts Exchange (http://www.experts-exchange.com/articles/18880/PaperPort-14-in-Windows-10-A-First-Look.html), I discussed my nine-month sandbox testing of the Windows 10 Technical Preview, specifically with respect to r…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now