May 21, 2003 at 10:44 am
When SQL Server intially starts it does not eat up much memory, but it appears as soon as I run a query or Crystal Report the memory usage by SQL spikes way up. Now normally I wouldn't mind, but I am finding that even after the report/or sql query is done running, SQL Server is not releasing the memory. It just continues to hold it.
Any help whould be great.
Thanks in advance.
May 21, 2003 at 11:23 am
That is expected behavior. As it caches data it will hold it to make subsequent queries faster.
Andy
May 21, 2003 at 12:03 pm
How do I keep it from eating all my memory up?
That is expected behavior. As it caches data it will hold it to make subsequent queries faster.
Andy
http://www.sqlservercentral.com/columnists/awarren/
[/quote]
May 21, 2003 at 12:40 pm
Why do you want to limit the available memory to your SQL Server?
You can configure "max server memory (MB)" either from sp_configure or EM.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply