-- if hardware memory less than 6gb awe enable it

sp_configure 'show advanced options', 1
RECONFIGURE
GO

sp_configure 'awe enabled', 1
RECONFIGURE
GO

-- restart the computer  



-- Get configuration values for instance
SELECT name, value, value_in_use, [description]
FROM sys.configurations
ORDER BY name;

-- Set max server memory = 59000MB for the server
-- (example value only)
EXEC sp_configure 'max server memory (MB)', 4800;
GO
RECONFIGURE;
GO

-- Some suggested Max Server Memory settings
-- Physical RAM     Max Server Memory Setting
--    4GB            3200
--    6GB            4800
--    8GB            6200
--    16GB           13000
--    24GB           20500
--    32GB           28000
--    48GB           44000
--    64GB           59000
--    72GB           67000
--    96GB           90000

-- Enable optimize for ad-hoc workloads
-- (new in SQL Server 2008)
EXEC sp_configure 'optimize for ad hoc workloads', 1;
GO
RECONFIGURE;
GO


-- Set MAXDOP = 1 for the server
-- Depends on workload and wait stats
EXEC sp_configure 'max degree of parallelism', 1;
GO
RECONFIGURE;
GO