/********************************************************************************
 *				
 * Program Name:	fix_huge_servers.sql
 *
 * Program Description: Adjust SQL Server settings for big boxen
 *
 * Usage:		Fire and forget
 *
 * NOTE:		When installing any software that registers DLLs,
 *			you must boot in NON-PAE mode. Before doing this,
 *			lower the MAX SERVER MEMORY setting to 1024MB
 *			else a bunch of services won't be able to start [JE]
 *
 * Author:		John Eisenschmidt <jeisenschmidt@feldinc.com>
 *
 * Date:		2004-04-12 - Created
 *			2004-06-25 - Changed from 6GB to 4GB [JE]
 *			2004-07-28 - Added affinity mask [JE]
 *			2004-12-28 - Turn off AWE mode (does not play well
 *				     with other applications, changed max
 *				     memory from 4096MB to 3072MB [JE]
 *			2004-12-29 - Lowered to 2048MB (stupid CE) [JE]
 *			2005-02-14 - Turned AWE back on [JE]
 *
 ********************************************************************************/

-- http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_6rw2.asp
-- only allow sql server to use cpus 2-5
-- 0 and 1 reserved for OS and lawson
-- 6 and 7 reserved for deferred process call (dpc), has 2 NICs
-- 00111100 binary == 60 decimal
sp_configure 'affinity mask',60
go
reconfigure
go

-- address windowing extension, support up to 64gb ram
--sp_configure 'awe enabled',1
sp_configure 'awe enabled',0
go
reconfigure
go

-- this uses NT fibers instead of threads, good for systems
-- with > 20000 context switches per second
--sp_configure 'lightweight pooling',1
--go
--reconfigure
--go

-- set the max memory SQL can use to 4GB
--sp_configure 'max server memory',4096
--sp_configure 'max server memory',3072
sp_configure 'max server memory',2048
go 
reconfigure
go

sp_configure 'show advanced options',1
go
reconfigure
go

sp_configure