Enable awe on cluster box
-
Hi,
I am Planning to enable awe for a particular Sql server instance on two node cluster box with 4 instances, here are few questions:
1) Grant the SQL service account, the ability to ‘lock pages in memory’ - should this be done on both the NOdes (1 and 2)?
2) The request is to enable awe for 12 GB usage :
sp_configure 'max server memory', 12000
RECONFIGURE
GO
( should I specific 12000 or some other number, as per other
samples, which is always a higher number. if the requirement is 6GB, they use 6144MB as the parameter.)
3) Stop and restart SQLE instance - this has to be done through the
Cluster adminstrator ?
4) After implementing, how do we verify that sql server instance is using 12 GB RAM. Hints or links to articles, will be help.
Thanks.
Windows 2003 DataCenter Server
Memory 16223
SQL SERVER 2k ENTERPRISE
-
Did you read http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp
1) Yes
2) How much is your total server memory per node ?
If you use AWE with SQL2000 SQLserver will grab all memory ('max server memory') at startup of the instance
Check out http://www.sql-server-performance.com/awe_memory.asp
First check your BOOT.INI parameters (to activate you'll need to reboot the node)
sp_configure 'max server memory', 12000
RECONFIGURE
GO
sp_configure 'awe enabled', 1
reconfigure
go
3) On a cluster you always use ClusterManager to stop/start/move resourcegroups
4) Use perfmon (not task manager !) to check your memoryallocation
or the usual sqlserver tools
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
the total memory to each instance should be 2.5Gb
It's generally best to leave around 2gb of total memory when using awe.
with instances you must divide the available memory between them otherwise you may have starvation issues.
you'd use something like this for each instance
exec dbo.sp_configure 'max server memory',2560
exec dbo.sp_configure 'awe enabled',1
reconfigure with override
go
awe disables dynamic memory management so you must set max memory to limit memory, min memory does nothing as awe memory is allocated at start up and is never released.
as mentioned above you need /PAE switch in boot.ini of all nodes and no '3GB switch
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply