MS SQL 2000 memory leak
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
Software/Hardware used:
Software/Hardware used:
ASKED:
November 10, 2007 12:52 PM
UPDATED:
December 2, 2007 11:57 AM
Answer Wiki:
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>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
