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 |
|
JaybeeSQL
Posting Yak Master
112 Posts |
 Posted - 2012-07-16 : 10:25:20
|
| Hi all, I am trying to used fixed memory size but it automatically resets itself to the default (dynamically configure) when I re-enter the settings dialogue.Please advise,JB |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-07-16 : 10:43:27
|
| How did you change the setting? Did you use sp_configure with RECONFIGURE? |
 |
|
|
JaybeeSQL
Posting Yak Master
112 Posts |
Posted - 2012-07-16 : 12:38:37
|
| Ran the code and then rebooted the service, which now shows the desired min/max settings (which are identical btw) |
|
|
|
JaybeeSQL
Posting Yak Master
112 Posts |
Posted - 2012-07-17 : 05:27:10
|
| Oh, and thanks Rob. :) |
|
|
|
|
|
|
Fixed Memory unavailable