[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Page file usage over 2GB in SQL server 2005 Standard edition

Posted on 2009-04-22
11
Medium Priority
?
372 Views
Last Modified: 2012-05-06
Hi Experts,
we have a microsoft SQL server 2005 standard edition running on a Windows server 2003 enterprise edition box which has a quad core processor and 4GM of RAM. i've set the min memory at 1000mb and max memory at 3000mb on the SQL configuration but havent enabled the AWE option as i only have 4GB to work with. But still the users report that the server is performing slow and when i look at the page file usage its always over 2GB. Can anyone of you tell me what i should do? will increasing memory and enabling AWE afterwards help?
0
Comment
Question by:ananmanan
  • 6
  • 5
11 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24212344
As a first step, you can use SQL profiler to view which activity making load on your server. you can check whenther indexes are there or not on heavy tables.
0
 
LVL 1

Author Comment

by:ananmanan
ID: 24224777
Hi Experts,
Thank you for the links above but i can't find any item that can effect the performance of the server in the SQL Profiler as none of the processes go above 25MB. Will it work if i increase the memory to 8GB and enable AWE on the SQL server? what will be the best setting for the upper and lower limits of the SQL memory configuration in MBs. Have you head of any Worms or malware which can cause a SQL 2005 server to under perform. When the server boots it takes a lot of time to apply personal settings and when you try to open the SQL management studio it takes a lot of time. Will defragmenting and Memory increase help? i'm stumped!! help....
 
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
LVL 31

Expert Comment

by:RiteshShah
ID: 24224858
you have 4GB RAM how could you increase it with 8GB without having it physically. After looking at your detailed scenario, I think you might have malware or something which is utilizing your memory. Moreover, have you check your startup items of windows? have you find any unnecessory task there? this could also be a reason to make your profile loading slow.

Moreover, is your Win 2003 box is having AD?
0
 
LVL 1

Author Comment

by:ananmanan
ID: 24230643
Hi Master,
I was planning on adding 4GB of RAM physically to increase upto 8GB. Yes you were correct i found out that there was a worms called Worm_Kablam.a when i scanned the 2003 box. Do you know whether this worm is capable of doing this? i dont have physical access to the server on weekends to remove the worm in safe mode So can i keep this Question alive till monday when i can try doing this to see if it fixes the issue. Anyway the 2003 box doesnt have AD on it.
 
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24230662
the worm you said is known for information theft and it must be utilizing your processing power and your network resources to send your data to its server. However, it is not much risky as it is not going to harm any file on your server.
0
 
LVL 1

Author Comment

by:ananmanan
ID: 24231952
Have you heard of any good malware removal tools that i can use to remove this Worm?What would you recommend to remove this Worm?
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24231957
well when I have received this worm, i have used trend micro office tool
0
 
LVL 1

Author Comment

by:ananmanan
ID: 24238503
Hi Master,

I have trend micro myself but it only quarentines the worm but says it can't remove it so how can i remove it? once it was quarentined the subsequent scans that i ran from trend didnt catch the worm so is it safe to assume that the worm was taken care of by Trend?  is there anyway to block these worms from getting into the server in the future?
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
ID: 24238517
well, its quarentined so no need to worry about, there is no way to prevent your system except keeping good live virus and malware scanner.

0
 
LVL 1

Author Closing Comment

by:ananmanan
ID: 31573658
Thank you Expert for your help!!!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Loops Section Overview
Screencast - Getting to Know the Pipeline

834 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