Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fshguo
Starting Member
4 Posts |
 Posted - 2008-03-29 : 17:36:09
|
| Hello, I understand that we should use SSMS -> Server Properties -> Memory to put a cap on the SQL server memory usage, therefore it gives some space memory for OS, this is based on the fact if the max memory is not specified, SQL will use whatever available memory and eventually crash the system. My question is that when a server has SSIS and SSAS services installed along with the SQL service. Would the max memory setting covers the SSIS and SSAS memory usage, or the SSIS and SSAS has to shared the memory with OS? Thanks,fshguo. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-29 : 20:21:59
|
| How much memory your server has ? It is included in the max memory also. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
|
|
fshguo
Starting Member
4 Posts |
Posted - 2008-03-29 : 22:27:16
|
| The server has 16G memory, the MAX memory in SQL is set to 12G. According to RMIAO's comment the rest of 4G is shared among OS, SSAS and SSIS. While SODEEP's comment is totally opposite: the SSAS and SSIS is within 12G along with SQL service. You can see I am still confuse, can either one of you please confirm your explanation with some sort of white paper...Thanks a lot,fshguo. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-29 : 22:45:23
|
| You can check numbers in perfmon. I have server with 128gb memory, installed sql/ssis/ssas on it. Sql server hse max memory of 64gb, ssas has min memory of 32g, rest for ssis and os. |
|
|
|
fshguo
Starting Member
4 Posts |
Posted - 2008-03-30 : 20:21:57
|
| Thanks RMIAO. How and where you specify the min memory for SSAS? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-30 : 20:47:51
|
| In msmdsrv.ini, you can find it in C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Config (may differ on your machine). Also take look at kb article 'SQL Server 2005 Analysis Services (SSAS) Server Properties'. |
|
|
|
|
|
|
|
|
if max memory settings in SQL including the SSAS