Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-03-18 : 13:49:50
|
Just curiousIf SQL server is configured to use 500Mb max in the server properties box, should it release that memory back to the system when the server is idle or not Sam |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-18 : 13:55:09
|
| No it should not. SQL Server will only release the memory if another application is requesting it AND SQL Server no longer needs the memory. SQL Server is designed to be a memory hog, which is why it is imperative to have sufficient memory on the server and to configure SQL Server to use as much memory as possible and needed.Tara |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-03-19 : 17:41:42
|
| Just to add that max server memory controls the size of the buffer pool not the total memory the sqlservr.exe process will consume. It's likely that private bytes will exceed max server memory. For durther info see BOL and [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363[/url]HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-19 : 17:42:59
|
| I should always add that article when discussing the max server setting since it is very important that people understand this setting.TaraEdited by - tduggan on 03/19/2003 17:43:15 |
|
|
|
|
|
|
SQL Memory Utilization