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
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