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

CPU queries in SQL server

-- Database Wise CPU Utilization report -- CPU_Time(Ms): CPU Time in Milliseconds -- CPUPercent: Let’s say this instance is using 50% CP...