Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Configure Physical Memory


Configure Physical Memory

Author
Message
y.koteswarrao-652921
y.koteswarrao-652921
SSC Journeyman
SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)

Group: General Forum Members
Points: 80 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
magasvs
magasvs
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1321 Visits: 752
Do you have Windows and SQL Server 32 bit or 64 bit?
Shawn Melton
Shawn Melton
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1293 Visits: 3504
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
magasvs
magasvs
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1321 Visits: 752
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.
y.koteswarrao-652921
y.koteswarrao-652921
SSC Journeyman
SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)

Group: General Forum Members
Points: 80 Visits: 199
Hi,

We are using 32bit sqlserver
y.koteswarrao-652921
y.koteswarrao-652921
SSC Journeyman
SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)

Group: General Forum Members
Points: 80 Visits: 199
Hi

We are using 32bit sqlserver
sqlbuddy123
sqlbuddy123
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1462 Visits: 2243
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
y.koteswarrao-652921
y.koteswarrao-652921
SSC Journeyman
SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)

Group: General Forum Members
Points: 80 Visits: 199
Hi,

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

koteswarrao
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search