|
Home > Archive > MS SQL Server Clustering > August 2005 > Memory configuration for SQL2k cluster
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Memory configuration for SQL2k cluster
|
|
|
| I've built a single-instance Win2k3 based cluster and installed SQL2ksp3
on it. One active server has 8GB RAM, another passive server only has 4GB RAM.
and added /3GB /PAE into boot.ini
[boot loader]
timeout=5
default=multi(0)disk
(0)rdisk(0)partition
(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk
(0)partition(2)\WIND
OWS="Windows Server 2003, Enterprise" /fastdetect /3GB /PAE
and enable AWE and configure a limit of 6 GB for max server memory,
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
sp_configure 'show advanced options', 0
RECONFIGURE
GO
and reboot system.
But the sqlserver.exe process only take 2796M memory, is it normal?
| |
| Andrew J. Kelly 2005-08-16, 3:23 am |
| What do the SQL Server perfmon counters for Target and Total memory show? Task manager is not the right tool to look at SQL Server memory usage.
--
Andrew J. Kelly SQL MVP
"bonse" <bonse742@taeco.com> wrote in message news:uvwuNKgoFHA.1044@tk2msftngp13.phx.gbl...
I've built a single-instance Win2k3 based cluster and installed SQL2ksp3
on it. One active server has 8GB RAM, another passive server only has 4GB RAM.
and added /3GB /PAE into boot.ini
[boot loader]
timeout=5
default=multi(0)disk
(0)rdisk(0)partition
(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk
(0)partition(2)\WIND
OWS="Windows Server 2003, Enterprise" /fastdetect /3GB /PAE
and enable AWE and configure a limit of 6 GB for max server memory,
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
sp_configure 'show advanced options', 0
RECONFIGURE
GO
and reboot system.
But the sqlserver.exe process only take 2796M memory, is it normal?
| |
| Uttam Parui[MS] 2005-08-22, 3:23 am |
| As per SQL Server Books Online topic "Managing AWE Memory"
Use System Monitor (Performance Monitor in Microsoft Windows NTŪ 4.0) to retrieve information on SQL Server memory usage and available memory. Task Manager does not provide accurate memory usage
information for AWE. Therefore, the memory quoted for sqlservr.exe is NOT correct. To obtain the correct amount of SQL Server memory usage, you can use the Total Server Memory (KB) performance counter,
activated through System Monitor, or select the memory usage from sysperfinfo. For more information, see Monitoring Memory Usage.
Also, make sure that the MSSQLServer service account has been assigned the "Lock Pages in Memory" privilege on both nodes.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|
|
|
|
|