set max memory to 800 MBs while it is using 1.7 Gs  
Author Message
unofarmbob





PostPosted: Mon Mar 14 14:22:13 CST 2005 Top

SQL Server >> set max memory to 800 MBs while it is using 1.7 Gs

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 Server230  
 
 
Michael





PostPosted: Mon Mar 14 14:22:13 CST 2005 Top

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.
>


 
 
Gert-Jan





PostPosted: Tue Mar 15 13:13:23 CST 2005 Top

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.