SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Max memory for sql server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ahmeds08
Aged Yak Warrior

India
655 Posts

Posted - 10/06/2012 :  15:40:56  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
Dear Experts,
Need you advise on,
what should be the maximum memory to be set for sql server running data warehouse.
my server configuration is:
32 GB RAM.
with 7 databases on it.
each database currently is around 100 GB.
It also has SSRS,SSIS,SSAS configured on it.

Thanks.

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/06/2012 :  15:46:36  Show Profile  Visit tkizer's Homepage  Reply with Quote
If it were dedicated to just the databases, I'd start at 28GB. I'm not sure of the memory requirements of the other products, but maybe start with 20GB and see how everything does.

Are you using 64-bit?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

ahmeds08
Aged Yak Warrior

India
655 Posts

Posted - 10/06/2012 :  16:04:16  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
quote:
Originally posted by tkizer

If it were dedicated to just the databases, I'd start at 28GB. I'm not sure of the memory requirements of the other products, but maybe start with 20GB and see how everything does.

Are you using 64-bit?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



Hi Tara,
Thanks for the info.
Yes it is 64 bit.
So,as you mentioned does sql server really utilize 20 or 28 GB of RAM if given.

Thanks.
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 10/06/2012 :  18:58:21  Show Profile  Reply with Quote
SQL OS will grab as much memory as it is allowed to and does its own memory management. It may not do so initially when you start up the server, but when you run queries it will gradually take up more and more memory up to the limit it is allowed to. What it does is hold on to the memory it grabbed (which allows it to keep data, query plans etc. in memory, so if the same data is needed again, it can provide a faster turn-around).
Go to Top of Page

ahmeds08
Aged Yak Warrior

India
655 Posts

Posted - 10/07/2012 :  03:24:07  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
quote:
Originally posted by sunitabeck

SQL OS will grab as much memory as it is allowed to and does its own memory management. It may not do so initially when you start up the server, but when you run queries it will gradually take up more and more memory up to the limit it is allowed to. What it does is hold on to the memory it grabbed (which allows it to keep data, query plans etc. in memory, so if the same data is needed again, it can provide a faster turn-around).



Sunita,
Thanks for the detail.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 10/07/2012 :  13:34:46  Show Profile  Visit jackv's Homepage  Reply with Quote
Some othe rconsiderations may include :
a) Lock Pages in Memory. Yes or No ? This will depend on different scenarios. The main benefit of turning it on is that the buffer pool buffer doesn't get paged out.

b) Consider how much memory the other apps may take - such as AntiVirus

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

ahmeds08
Aged Yak Warrior

India
655 Posts

Posted - 10/08/2012 :  06:32:40  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
quote:
Originally posted by jackv

Some othe rconsiderations may include :
a) Lock Pages in Memory. Yes or No ? This will depend on different scenarios. The main benefit of turning it on is that the buffer pool buffer doesn't get paged out.

b) Consider how much memory the other apps may take - such as AntiVirus

Jack Vamvas
--------------------
http://www.sqlserver-dba.com



Thanks Jack,
Will look into them.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 10/08/2012 :  10:44:54  Show Profile  Visit jackv's Homepage  Reply with Quote
let us know how you get on

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000