Memory Usage for SQL SERVER 2000

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

General SQL Server Forums

New to SQL Server Programming

Memory Usage for SQL SERVER 2000

Author

Topic

MelvinT
Starting Member

5 Posts

Posted - 2006-03-23 : 19:15:38

Good day to all of you
I am faced SQL SERVER 2000 Memory usage problem. I am using Windows 2000 Server SP4 and SQL SERVER 2000 SP4. When User running some in-house application software, the memory for sqlservr.exe was increased . But, when user logout from the software. The sqlservr.exe did not decrease the memory. I have around 100 Users in my company. SQL Memory will countinues increase till max memory usage in CPU.

May i know how to order SQL SERVER need to purge memory when USER was log off from the Program? Or my SQL SERVER was corrupted /missing file?

Please advice

Many thanks!
Melvin

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-03-23 : 20:01:25

SQL Server is working the way it was designed to work. When it takes memory, it does not return it unless the operating system runs low on memory.

It does this in order to increase performance. The more memory that it has available for data buffers, the less often it will have to read data from disk.

You should read about memory usage and memory settings in SQL Server Book Online.

CODO ERGO SUM

MelvinT
Starting Member

5 Posts

Posted - 2006-03-24 : 01:52:25

thank you, Micheal.

I am new in SQL, hope you can provide me your Prof. advice to me
Let say, my SERVER is running 1GB RAM. Sqlservr.exe has taken 850MB from my SERVER Memory. Do you think it's normal way for SQL SERVER running? Or i have attacked by SQL Slammer (But i scan my SERVER and look like pretty good)

Please advice

Thank you

Best regards,
Melvin

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-03-24 : 02:31:09

quote:
Originally posted by MelvinT

thank you, Micheal.

I am new in SQL, hope you can provide me your Prof. advice to me
Let say, my SERVER is running 1GB RAM. Sqlservr.exe has taken 850MB from my SERVER Memory. Do you think it's normal way for SQL SERVER running? Or i have attacked by SQL Slammer (But i scan my SERVER and look like pretty good)

Please advice

Thank you

Best regards,
Melvin

This is normal behavior.

-ec

MelvinT
Starting Member

5 Posts

Posted - 2006-03-24 : 21:15:42

Thank you!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources