SQL Server >> set max memory to 800 MBs while it is using 1.7 Gs
It won't have any effect until you stop and restart the SQL Server service.
> One instance I have is using 1.7 Gs memory now. I need to set its max
> memory to be 800 MBs.
>
> What happens if I just go ahead and set it to be 800 MBs while it is live?
> Will it crash the server? Do I have to reboot after the setting?
>
> Thank you.
>
SQL Server >> set max memory to 800 MBs while it is using 1.7 Gs
SQL-Server will automatically release the excess memory. However, it
make take a while before this kicks in. It will not crash the server,
but could result in a temporary performance hit.
HTH,
Gert-Jan
>
> One instance I have is using 1.7 Gs memory now. I need to set its max
> memory to be 800 MBs.
>
> What happens if I just go ahead and set it to be 800 MBs while it is
> live? Will it crash the server? Do I have to reboot after the setting?
>
> Thank you.