Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Memory Best Practice Configuration

  
   Database Forums (Home) -> Setup RSS
Next:  Design In Access 2007 Then Compile In A2003 Quest..  
Author Message
Vittorio Pavesi

External


Since: Oct 31, 2008
Posts: 3



(Msg. 1) Posted: Fri Oct 31, 2008 5:25 am
Post subject: Memory Best Practice Configuration
Archived from groups: microsoft>public>sqlserver>setup (more info?)
Hello,
I've a Windows 2003 x64 cluster with SQL Server Standard 2005 with 2
instances (Active/Active), Each node has 8 GB RAM, Max Memory parameter
has default value (2147483647).

We're going to upgrade RAM to 16 GB on each node. What is the best
configuration for Max Memory (with either 8 and 16 GB)?

Thanks in advance

Vittorio Pavesi

 >> Stay informed about: Memory Best Practice Configuration 
Back to top
Login to vote
Andrew J. Kelly

External


Since: Sep 01, 2003
Posts: 975



(Msg. 2) Posted: Fri Oct 31, 2008 7:31 pm
Post subject: Re: Memory Best Practice Configuration [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
You have to consider that at some point both instances will be running on 1
node and will have to share the total memory between them. So you might want
to set MAX Memory in each instance such that the combined total is about 7
or 14GB depending on the total. You need to determine which instance needs
more or less than the other and set it accordingly.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Vittorio Pavesi" wrote in message

> Hello,
> I've a Windows 2003 x64 cluster with SQL Server Standard 2005 with 2
> instances (Active/Active), Each node has 8 GB RAM, Max Memory parameter
> has default value (2147483647).
>
> We're going to upgrade RAM to 16 GB on each node. What is the best
> configuration for Max Memory (with either 8 and 16 GB)?
>
> Thanks in advance
>
> Vittorio Pavesi

 >> Stay informed about: Memory Best Practice Configuration 
Back to top
Login to vote
Ekrem_Önsoy

External


Since: Aug 29, 2007
Posts: 192



(Msg. 3) Posted: Sat Nov 01, 2008 2:25 pm
Post subject: Re: Memory Best Practice Configuration [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
And of course you need to consider the memory needs of other
applications -if there is any on that server.

--
Ekrem Önsoy



"Vittorio Pavesi" wrote in message

> Hello,
> I've a Windows 2003 x64 cluster with SQL Server Standard 2005 with 2
> instances (Active/Active), Each node has 8 GB RAM, Max Memory parameter
> has default value (2147483647).
>
> We're going to upgrade RAM to 16 GB on each node. What is the best
> configuration for Max Memory (with either 8 and 16 GB)?
>
> Thanks in advance
>
> Vittorio Pavesi
 >> Stay informed about: Memory Best Practice Configuration 
Back to top
Login to vote
Vittorio Pavesi

External


Since: Oct 31, 2008
Posts: 3



(Msg. 4) Posted: Mon Nov 03, 2008 4:25 am
Post subject: Re: Memory Best Practice Configuration [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Andrew J. Kelly wrote:
> You have to consider that at some point both instances will be running
> on 1 node and will have to share the total memory between them. So you
> might want to set MAX Memory in each instance such that the combined
> total is about 7 or 14GB depending on the total. You need to determine
> which instance needs more or less than the other and set it accordingly.
>
Really thanks

Vittorio
 >> Stay informed about: Memory Best Practice Configuration 
Back to top
Login to vote
Vittorio Pavesi

External


Since: Oct 31, 2008
Posts: 3



(Msg. 5) Posted: Mon Nov 03, 2008 4:25 am
Post subject: Re: Memory Best Practice Configuration [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Ekrem Önsoy wrote:
> And of course you need to consider the memory needs of other
> applications -if there is any on that server.
>
Really thanks

Vittorio
 >> Stay informed about: Memory Best Practice Configuration 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Best practice - disks/RAID - I am looking to order hardware for a new SQL server to run SQL 2005 for a high utilisation database (lots of database writes). We don't have a SAN so I was looking to spec a server with 8 15k SAS drives configured as RAID 10 as all docs seem to point....

The default configuration Don't work on XP Home -

finding out sql server configuration programattically - Hi, I have a sql server 2005 and I wish to find out the following configurations from within a program: a. is the clr enabled feature is on b. is the remote connection options support named pipes I would like to know if there is a query/table/registry....

SQL Server Surface Configuration not working after change .. - Hi: I've setup a SQL Server 2005 Standard x64 in a cluster configuration on two Windows 2003 R2 SP2 servers. After a lot of work, everything seem to be working fine, ie the services would migrate correctly, etc. I then started going through the..

Best Practice Guide installing SQL Server 2005 Enterprise .. - Looking for a best Practice Guide when installing SQL Server 2005 Enterprise Edition Non - Cluster Windows Server 2003 Standard
   Database Forums (Home) -> Setup All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]