January 13, 2012 at 5:53 am
Hi,
1. OS - windows server 2008 R2 64 bit enterprise edition
2. Database - SQL 2K8 R2 - 64 bit enterprise edition.
3. 32 GB - Physical RAM.
In this server not dedicated SQL database and other two application also running. if running only SQL no need to setting max memroy better to leave default setting.
there are two third party application are going to installed this server..could anyone suggestion me, How much memory should be allocated in SQL side?
Is it sufficient as below setting at production server?
EXEC sp_configure‘max server memory (MB)’,21500;
GO
RECONFIGURE;
GO
For the 64 bit SQL server 2k8 R2 version. , Is it not recommended to set the AWE setting? please confirm
thanks
ananda
January 13, 2012 at 6:13 am
ananda.murugesan (1/13/2012)
if running only SQL no need to setting max memroy better to leave default setting.
Nope. Almost always better to set it
there are two third party application are going to installed this server..could anyone suggestion me, How much memory should be allocated in SQL side?
Not enough information to answer that. It needs to be low enough that SQL's memory usage + that of the applications + required by OS <= total server memory. So first you need to know how much memory the applications use at their peak.
For the 64 bit SQL server 2k8 R2 version. , Is it not recommended to set the AWE setting? please confirm
On 64 bit, the AWE setting is completely ignored.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 16, 2012 at 12:20 am
Thanks Gail for your reply.. I will do it Max memory setting after installation and absolute usages of these third party application like LTO, symantec and application software..
For the general preparation of setting Max memory setting on SQL SERVER 2008 R2 instance of 32 GB RAM.
OS 3GB +third party 2GB,+Application software 3GB + SQL 24 GB <=32 GB total RAM.
-------------------------------------------------------------------------
One more question for Lock page memory setting. It means to Reduce Paging of buffer pool memory in the 64-bit version of SQL Server 2k8 R2.
Does OS win2k8 R2 64 bit and SQL 2k8 R2 64 bit are both installation on server, Is it not required enable Lock Page Memory setting? please confirm
thanks
ananda
January 16, 2012 at 1:46 am
Just make sure that's not an estimate on the high side.
As for locked pages - http://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply