8GB RAM in SQL Server

Hi,
I'm just designing a server... What can I do with 8GB RAM in the Box?
Analysis Services is limited to 8GB. The Enterprise Edition of SQL Server
can use max.8GB RAM. Windows 2003 Enterprise Edition can use 8GB, too.
So I can use 3GB for Analysis Services and the remaining 5GB are used for
SQL Server and the OS? Is this right?
Thanks
ThomasActually, there is no direct answer for this. It depends
on how much memory the analysis server requires for cubes
and memory required for SQL Server.
It also depends on any other applications running on the
same box.
In General, You have to allocate for OS,SQLServer,analysis
Server and then for other applications.
Please read this to get some idea on how SQL Server memory
works. http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_config_9zfy.asp
Also , read "memory architecture" from BOL.
To allocate memory for Analysis Server, stop and start the
analysis services and open the task manager and look for
memory used by the processess "msmdsrv.exe"
and "msmdvldm.exe". The sum of these memory is minimum
required for analysis services to start.
SQLVarad (MCDBA-1999,MCSE-1999)
>--Original Message--
>Hi,
>I'm just designing a server... What can I do with 8GB RAM
in the Box?
>Analysis Services is limited to 8GB. The Enterprise
Edition of SQL Server
>can use max.8GB RAM. Windows 2003 Enterprise Edition can
use 8GB, too.
>So I can use 3GB for Analysis Services and the remaining
5GB are used for
>SQL Server and the OS? Is this right?
>
>Thanks
>
>Thomas
>
>.
>|||Hi,
thanks, that pointed me in the right direction...
Thomas
"SQLVarad" <SQLVarad@.hotmail.com> schrieb im Newsbeitrag
news:010c01c3a3d4$6cc8f790$a601280a@.phx.gbl...
> Actually, there is no direct answer for this. It depends
> on how much memory the analysis server requires for cubes
> and memory required for SQL Server.
> It also depends on any other applications running on the
> same box.
> In General, You have to allocate for OS,SQLServer,analysis
> Server and then for other applications.
> Please read this to get some idea on how SQL Server memory
> works. http://msdn.microsoft.com/library/default.asp?
> url=/library/en-us/adminsql/ad_config_9zfy.asp
> Also , read "memory architecture" from BOL.
> To allocate memory for Analysis Server, stop and start the
> analysis services and open the task manager and look for
> memory used by the processess "msmdsrv.exe"
> and "msmdvldm.exe". The sum of these memory is minimum
> required for analysis services to start.
> SQLVarad (MCDBA-1999,MCSE-1999)
>
> >--Original Message--
> >Hi,
> >
> >I'm just designing a server... What can I do with 8GB RAM
> in the Box?
> >Analysis Services is limited to 8GB. The Enterprise
> Edition of SQL Server
> >can use max.8GB RAM. Windows 2003 Enterprise Edition can
> use 8GB, too.
> >So I can use 3GB for Analysis Services and the remaining
> 5GB are used for
> >SQL Server and the OS? Is this right?
> >
> >
> >Thanks
> >
> >
> >Thomas
> >
> >
> >.
> >