| Author |
 Topic  |
|
|
ahmeds08
Constraint Violating Yak Guru
India
423 Posts |
 Posted - 10/06/2012 : 15:40:56
|
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
35007 Posts |
|
|
ahmeds08
Constraint Violating Yak Guru
India
423 Posts |
|
|
sunitabeck
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 10/06/2012 : 18:58:21
|
| 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). |
 |
|
|
ahmeds08
Constraint Violating Yak Guru
India
423 Posts |
Posted - 10/07/2012 : 03:24:07
|
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. |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1765 Posts |
Posted - 10/07/2012 : 13:34:46
|
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 |
|
|
|
ahmeds08
Constraint Violating Yak Guru
India
423 Posts |
Posted - 10/08/2012 : 06:32:40
|
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. |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1765 Posts |
|
| |
Topic |
|
Max memory for sql server
