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

How much memory should be allocated to SQL Server ? Expand / Collapse
Author
Message
Posted Wednesday, February 24, 2010 12:47 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:52 PM
Points: 1,532, Visits: 2,575
Dear All,

I have a dedicated server for SQL server database.
It has got 16 GB memory, windows server 2003.
SQL server 2005 64 bit with SP3.
Database size is 260GB

There is no any other application which needs any considerable amount of memory.

Approximately 125 users will be accessing SQL server simaltaneously.

So, Idealy, how much memory should I allocate to SQL Server ?


Thanks in advance.
Post #871759
Posted Wednesday, February 24, 2010 1:22 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:39 PM
Points: 42,953, Visits: 36,110
12-14 GB. No more (and I'd err on the lower end of that). OS needs memory to manage memory, not good to starve it.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #871765
Posted Wednesday, February 24, 2010 1:42 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:52 PM
Points: 1,532, Visits: 2,575
Thanks,

At present only 4GB is allocated. Sometimes application runs very very slow.
Post #871775
Posted Wednesday, February 24, 2010 3:07 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:39 PM
Points: 42,953, Visits: 36,110
Joy Smith San (2/24/2010)
Sometimes application runs very very slow.


That isn't necessarily insufficient memory. Yes, memory may help, but you should also look at what's running and see what needs fixing/changing to make it run better.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #871803
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse