Win 2003 Server Enterprise Edition
SQL Server 2000 Standard Edition
12 GB of phsical RAM
Lots of disk space

SQL Server and Analysis Services are installed on the same machine

1. added /PAE in boot.ini
2. added /3GB in boot.ini
3. exec sp_configure 'show advanced options', 1
RECONFIGURE
4. exec sp_configure 'awe enabled', 1
RECONFIGURE

5. I need to exec sp_configure 'max server memory', xxxxxx

Q1: how much max memory should I allow sql server to have? If I give it 8
GB, does that include (or not include) the 3 GB for Analysis Services?

Q2: Anything else I can do (not to go to sql server enterprise editon) to
boot analysis services performance?

Thanks much.

Hi Christy,
A1) When you enable the 3GB switch, in effect you are asking windows to
donate 1Gb of its memory space to Analysis Services, in other words SQL and
AS will have their own memory spaces.
A2) What is the cause of the server loading - SQL is busy or very large
dimensions or lots of users? The cause needs to be determined to make it
clear what options you have.
Ta!
Paul

"christy" wrote:

Standard SQL will address a max of 2GB of RAM, not sure about AS...

"christy" <christy (AT) discussions (DOT) microsoft.com> wrote

Analysis Services Performance Guide
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
Has lots of recomemndations, tips, tricks and ideas.
Good reading!
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"christy" <christy (AT) discussions (DOT) microsoft.com> wrote