Limit SQL Server memory usage Use the sp_configure system stored procedure with the max server memory option to limit the amount of memory in the buffer pool used by an instance of SQL Server or MSDE. This will prevent SQL Server from using more than the specified amount of memory, thus leaving remaining memory available to start other applications quickly. Enable advanced options: USE masterEXEC sp_configure 'show advanced options', 1RECONFIGURE WITH OVERRIDE Set the maximum amount of memo 
Leggi tutto il post...