This script is used to check whether the 3gb switch is configured or not in the boot.ini file. This script is applicable for SQL server 2005 and above.
Script
IF(SELECT Virtual_Memory_In_Bytes/1024/(2048*1024) FROM Sys.dm_os_Sys_Info) < 1 BEGIN PRINT '/3GB Switch Not Configured in Boot.Ini (CHECK)' END ELSE BEGIN PRINT '/3GB Switch Configured in Boot.Ini' END
Sample Output
/3GB Switch Not Configured in Boot.Ini (CHECK)
Leave a Reply