Why doesn't SQL Server 7.0 release memory? I have 2 GB of memory and task manager says that Memory Usage is 1963228KB. There is hardly any activity on my application server, which means hardly anyone is on the server doing anything. Noone is doing anything directly to the database. How do I control SQL Server memory usage and how do I release this memory without rebooting all the time?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Releasing memory
- Thread starter lory
- Start date
tlbroadbent
MIS
You can set the Minimum and maximum memory usage, though this is not recommended. See the topic "Server Memory Options" in SQL Books Online. This article explains how SQL allocates (ad deallocates) memory and how to manually configure memory usage. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads
- Locked
- Question