SQL Server Performance Forum – Threads Archive
awe enable 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#%92 – 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’, 12000RECONFIGURE
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 (on both the nodes)
SQL SERVER 2k ENTERPRISE
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#%92 – should this be done on both the NOdes (1 and 2)? 2) Stop and restart SQLE instance – this has to be done through the
Cluster adminstrator ? 3) 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 (on both the nodes)
SQL SERVER 2k ENTERPRISE
if this is a active/passive cluster and both nodes have the same 16gb memory on them then – set the max server memory to 15gb with the same options you gave
– apart from that donot forget to set /3gb and /PAE switches in BOOT.INI file on both the nodes.
– reboot the nodes You still need to give "lock pages in memory" on the nodes for the sql server service account. if this is a active/active cluster and both nodes have the same 16gb memory on them then
specify less than 8GB for each instance. This is because in this case if the instances failover to one node then each instance will take the configured amount of memory per instance and the sum total is greater than the physical memory on the node then one of the instances may not come up at all.
If it is active/passive (one instance) donot use /3GB if your server has >12 GB free memory…and leave the 2 GB to OS and rest can be configured to SQL… Yes, you need to do Lock pages in memory on both nodes… When AWE is enabled memory is not dynamic, you are correct you need to start the sql services but it can’t be done through cluster admin or EM… You can use SQLServer:Memory Manager: Total Server Memory (KB) and SQLServer:Memory Manager: Target Server Memory (KB) counters to check the memory usage… Read the following articles for more info… How to configure SQL Server to use more than 2 GB of physical memory
http://support.microsoft.com/kb/274750 SQL Server for Developers
Inside SQL Server 2000’s Memory Management Facilities
http://msdn2.microsoft.com/en-us/library/aa175282(SQL.80).aspx
MohammedU.
Moderator
SQL-Server-Performance.com
]]>