MS SQL 2000 memory leak

pts.
Tags:
Memory leak
Microsoft SQL Server 2000
SQL
Hi We are running Adobe Workflow server which is based on SQL 2000. Both appliaction and SQL 2000 rside on the same server WIndows 2003. Lately we faced the problem of Time Out from Adobe and it seems to be that SQL is consuming allot of memeory. When checked Tak Manager we found out that sqlserver.exe service is consuming 1,728,420 MB out 4 GB of memory. How can we minimize this size of memory consumed by SQL to avoid this Time out problem

Answer Wiki

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

SQL Server is designed to use lots of memory. SQL Server caches data which is often used in memory. This takes lots of memory for it to be able to do. If you need to limit the amount of memory that SQL Server can use you can use the sp_configure procedure to change the setting.

This code will change the max amount of memory to 1024 Megs. To run it connect to the database using osql or another T/SQL command executing program.
<pre>exec sp_configure ‘max server memory’, 1024
reconfigure</pre>

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