disposition of SQL Server with maximum memory set to 0

Fault Description:when you remotely adjust the instance memory, the maximum memory is adjusted to 0, so the maximum RAM becomes the minimum value of 128MB. How to resolve:1. Gracefully shut down the SQL Server service, if it is a cluster, you need to shut down the cluster role first to prevent failover, and then shut down the service separately. -Note that this step may leave the instance in a suspended state for a long time, but normal shutdown is a must, and a direct kill process can cause data file corruption. 2. Launch the instance in "not as a service" mode. CD D:\Microsoft SQL server\mssql11. Mssqlserver\mssql\binn

Sqlservr.exe-smssqlserver-msqlcmd–c-f-M

This launches the SQL Server service separately in minimal configuration + single-user mode, taking care not to close the window, otherwise the service is closed.

3. Re-open a CMD window to connect to the database

SQLCMD-E--If it is a named instance: SQLCMD-E-S ip\< Instance name > Note that a named instance requires the SQL Server Browser service to be enabled to connect.

EXEC sys.sp_configure n ' Show advanced options ', n ' 1 '  RECONFIGURE with overridegoexec sys.sp_configure n ' max server me Mory (MB) ', n ' goreconfigure with overridegoexec sys.sp_configure n ' Show advanced options ', n ' 0 '  RECONFIGURE With Overridego

4. After modifying the memory, close the Sqlservr.exe window and restart the instance service.

disposition of SQL Server with maximum memory set to 0