Friday, February 24, 2012

Changing maximum memory option

If I change the Maximum Memory option (sp_configure or vai EM), do I need to restart the MSSQL service?
CliveNo restart of the service is required, anymore. At least in SQL 2000. If you do this via sp_configure, you will need to run reconfigure with override.|||Thank you for the quick reply.

No comments:

Post a Comment