Changing from Fixed to Dynamic Memory

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Changing from Fixed to Dynamic Memory

Author

Topic

schuhtl
Posting Yak Master

102 Posts

Posted - 2005-02-04 : 14:34:37

If you change the sql memory setting from fixed to dynamic or change the min & max values do you have to stop and restart the services or reboot? When viewing the memory via Spotlight the Total/Max values have not changed. Thanks in advance!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources