Check if /3GB is configured or not

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)


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *