Wednesday, January 3, 2018

[MSSQL] Set max server memory using command | 用指令設定伺服器最大記憶體

Few days ago I am testing a issue, set maximum server memory to very low (min limit 128 if you set the value below it) on SSMS, after apply the setting, SSMS pop out error , broken connection from SQL server and can't connect back due to the memory to low can't accept connection.

I take some time to find out how to change the setting from command line, here is the guide.