RS First Dynamics NAV Blog

...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

Limit SQL Server memory usage

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...
Categoria: Sql Server ALL
giovedì, 01 lug 2010 Ore. 14.27

Scrivi un commento

Non è possibile inviare commenti a questo Blog


Copyright © 2002-2007 - Blogs 2.0 | Home Page Blogs
ASP.NET 2.0 Windows 2003