Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Configure Physical Memory Expand / Collapse
Author
Message
Posted Tuesday, July 13, 2010 7:10 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 14, 2010 6:06 AM
Points: 76, Visits: 199
Hi

Iam having 32 GB of RAM, and i want to assign 25 GB of Physical Ram to SQlserver 2005.

Can do like this,

--By adding PAE switch and enabling the AWE in sql server
&
--Setting the max server in sqlserver..........
Do the above configuriation will do the needfull.......if i go wrong please let me guide to configure the 25 GB of Ram out of 32 GB Ram.

Koteswar Rao
Post #951420
Posted Tuesday, July 13, 2010 8:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, June 19, 2014 6:51 AM
Points: 1,264, Visits: 723
Do you have Windows and SQL Server 32 bit or 64 bit?
Post #951489
Posted Tuesday, July 13, 2010 8:50 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 2:25 PM
Points: 834, Visits: 2,280
As magasvs stated, a little bit more information is needed before suggestions or advice can be given.
What OS edition and 32 or 64 bit?
What SQL Edition (Enterprise, Standard, etc) and 32 or 64 bit?

There are numerous post on SSC and MSDN that deal with memory settings on SQL Server. A major player in the decision making process is what OS version you are running and if 64-bit or 32-bit.

If you are running Enterprise edition of OS and SQL on a 64-bit one of the main configuration settings you need to work on is the min and max memory settings for SQL Server. The AWE setting does not come into play on a 64-bit SQL instance. I would suggest utilizing Performance Monitor (perfmon) to find the happy medium on how much memory your instance of SQL is wanting and actually using.

The memory usage can change over time depending on what type of application is running against SQL Server, so you should always review this information frequently.


Shawn Melton
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #951510
Posted Tuesday, July 13, 2010 9:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, June 19, 2014 6:51 AM
Points: 1,264, Visits: 723
If you use SQL Server 64 bit then you need to add "Lock pages in memory" permissions to the SQL Server Service Account using Group Policy tool.
Post #951551
Posted Tuesday, July 13, 2010 11:20 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 14, 2010 6:06 AM
Points: 76, Visits: 199
Hi,

We are using 32bit sqlserver
Post #951687
Posted Tuesday, July 13, 2010 11:21 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 14, 2010 6:06 AM
Points: 76, Visits: 199
Hi

We are using 32bit sqlserver
Post #951690
Posted Tuesday, July 13, 2010 12:22 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:51 AM
Points: 1,194, Visits: 2,208
Hi Koteswara Rao,

As it is a 32-bit machine, use

1. PAE Switch -- On windows side
2. AWE -- On SQL Server Side
3. Max Memory Setting -- 25600 MB (25 GB) on SQL Server Side
4. Use Lock pages in Memory (Optional)-- To prevent paging out SQL Server memory pages -- On windows side.

On 64-Bit machine AWE is not needed.

Thank You,

Best Regards,
SQL Buddy
Post #951719
Posted Wednesday, July 14, 2010 1:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 14, 2010 6:06 AM
Points: 76, Visits: 199
Hi,

thanks alot for your reply...........

koteswarrao
Post #952105
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse