2011. 4. 18. 18:13

SQL 메모리 사용량


sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
 
sp_configure 'min server memory', 1024
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
 
http://technet.microsoft.com/ko-kr/library/ms190731(SQL.90).aspx
 
http://technet.microsoft.com/ko-kr/library/ms179301(SQL.90).aspx