Friday, 5 April 2013

How to configure AWE in SQL 2005/SQL 2008 on 32 bit Operating System?


How to configure AWE in SQL 2005/SQL 2008 on 32 bit Operating System?

Before you configure AWE ensure the database server has sufficient memory , ideal sceanio is Server RAM: 6GB , leave 2 GB for OS and other background running process, configure 4GB as AWE, check if awe is enabled or not first
Following steps needs to be performed
USE MASTER
GO
sp_configure 'show advanced options',1
go
reconfigure
Go
sp_configure 'min server memory (MB)','1024'
go
sp_configure 'max server memory', 4096
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO

No comments:

Post a Comment

How to find out recent differential backup history in SQL Server

-- Get Backup History for required database SELECT TOP 100 s.database_name, m.physical_device_name, CAST(CAST(s.backup_size / 1000000...