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 |
|
MichaelP
Jedi Yak
2489 Posts |
 Posted - 2004-01-16 : 16:32:07
|
| Hey all,Right now, I've got a SQL Server using Fixed memory size. We want to increase that Fixed size since we've added RAM to the server. My tests show that increasing the memory does not require a SQL Server restart, but decreasing it does (that makes sense). Does anyone know of any documentation that I can provide my admin to this fact?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-16 : 16:37:49
|
| You shouldn't have to restart for either. From BOL in the sp_cofigure topic:Minimum and maximum memory configurations are dynamic in SQL Server. You can change them without restarting the server.Tara |
 |
|
|
|
|
|
Fixed memory Size reconfiguring