SQL Memory Usage too low - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Memory Usage too low

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-10 : 08:03:14

Mixa writes "Hi there

I have a Windows 2000 Standard Edition Server (HP / Quad Xeon 2Ghz / 4 Gig Ram)

SQL Ver 8.00.194
Win2K Sp4

We recently Upgraded from 2Gig Ram to 4 Gig Ram and have not seen any improvement in speed etc.

Current Memory Usage By SqlServer is 1.7 Gig.
We have set SQL to Use Upto 3.5 Gig but It never goes above 1.7G

This SQL Server contains one Database of 50 Gig.
We have 80 Users accessing this Database and it's Very slow...

How can I get Sql to utilise more ram...
and therefore improve Performace?"

Stalker
Yak Posting Veteran

80 Posts

Posted - 2005-08-10 : 08:33:10

then the problem is not in memory but in something else, check prossessor load for example...

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-08-10 : 08:57:16

SQL Server 2000 Standard Edition can only use 2 GB of memory. If you want to use more, you will have to use Enterprise Edition.

SQL Server 2000 Product Overview
http://www.microsoft.com/sql/evaluation/overview/default.mspx

How to configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech

Evaluating why an application is slow is a complex task. Why do you believe that adding memory will improve performance?

CODO ERGO SUM

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-08-10 : 10:32:56

also, you should apply atleast Service Pack 3a to your SQL Server.

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-08-10 : 11:23:03

What is the task manager, windows performance monitor, and SQL Profiler telling you?

====================================================
Regards,
Sean Roussy

Thank you, drive through

cgunner
Yak Posting Veteran

95 Posts

Posted - 2005-08-10 : 13:35:55

Additionally, you have to specify the /3GB swithch in the boot.ini along with going to SQL EE edition.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-08-10 : 14:06:34

I just noticed that you are using Windows 2000 Standard Edition Server. According to the following article with Windows 2000 Standard, "The user-mode memory space is still limited to 2 GB." even if you set the /3GB switch.

http://support.microsoft.com/kb/291988/

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources