MS SQL Server 2000 and memory management

pts.
Tags:
SQL Server
I'm wondering why memory management even, in the newest versions of MS SQL Server (e.g SQL Server 2000), seems to be working very poorly. I'm facing problems with memory usage in a 5-10 user environment (3-4 simultaneous users). An VS.NET based application (iScala) is being used during working hours, and the memory usage of SQL Server processes is continously 1000 - 1250 meg (or more) even if users logoff form the system. The total amount of RAM is 2 GB on this server. The op.sys version in this case is SBS Server 2003. The problem is that the SQL Server is not releasing the memory until a total re-boot of the server. Is there a general approach to this problem ? I don't believe that the iScala application design would be main reason this memory problem. Kaj Bredenberg

Answer Wiki

Thanks. We'll let you know when a new response is added.

The SQL Server will only reduce memory based on the amount of virtual memory availble or when free physical memory is down below 64K (have read a low as 4K) and the OS is requiring memory for another process.

Try setting the phyical memory of the instance to a fixed size verus dynamic or reduce the high range for your dynamic settings.

The reason the SQL Server is “freeing” up memory on reboot is that the instance only uses what it needs (generally 64 to 128 M) at startup. This holds true even if the instance is set to a fixed size.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following