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 |
|
suinan
Starting Member
3 Posts |
 Posted - 2009-12-21 : 09:13:25
|
| Hi,I want to ask if it requires a restart to take effect after I set a max.memory usage limit for SQL server 2005.If I suddenly set the max. memory usage limit for SQL to 512MB while it is using 1.3GB, what gonna happen? Will the old data be deleted?Thanks. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-12-21 : 09:36:24
|
| It will slowly come down to the level you have set when the memory is released, but if you want it to take affect correctly and immediately, a restart of the service is advisable. |
 |
|
|
|
|
|
set SQL maxium memory usage