troubleshooting Question

Windows 2008 R2 | SQL 2008 R2 Express 64 bit - Info required about AWE, Locked pages to understand Memory usage

Avatar of techieeguy
techieeguy asked on
Microsoft SQL Server 2008Windows Server 2008
10 Comments1 Solution241 ViewsLast Modified:
Hi,

I was setting up a test lab to understand SQL server 2008 64 bit AWE/Lock pages feature and how it would effect Windows 2008 R2 server

My server config : I have 2 CPUS & 8 GB RAM

setup  SQL 2008 R2 Express 64 bit with instance name sqlexpress
enabled AWE, Set 5 GB of RAM as Minimum & Maximum
When i checked in taskmanger the memory usage is around 200 MB for sqlservr.exe process
And overall Physical Memory usgae is 600 MB
restarted my test server no luck
AM I missing something how to make SQL lock 5 GB which was allocated to it using AWE, Lock memory
Any help is highly appreciated

I tried using below command and also tried GUI
USE master
go
sp_configure 'show advanced options', 1
RECONFIGURE
EXEC sp_configure 'min server memory', 680 -- 2 GB min, replace with your desired amount here
EXEC sp_configure 'max server memory', 680 -- 6 GB min, replace with your desired amount here
RECONFIGURE WITH OVERRIDE

USE master -- database name
go
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO

Thanks in Advance
Techiee
ASKER CERTIFIED SOLUTION
Robert Schutt
Software Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros