Hi,

I want to monitor an AS2000 installation to see if and where we have any
bottlenecks in the cube processing. Does anyone know of a good document or
advice to offer. I have already read the SQL Server 2000 Resource Kit on
monitoring AS. It lists the counters to examine, but I'm not really sure what
would good figures and what would be poor ones.

We are using a 4 CPU box running Win2003.
The fact tables are stored in a SQL Server 2000 on the same box.

Thanks in advance.

standard best practices:

to correctly optimize your server:
1. Process & Monitor
2. change settings (like memory properties of AS)
3. Process & Monitor again...

You'll find the best parameters for your system.

also, try to process your partitions / cubes in parrallel.

put the distinct count measures in a dedicated cube

your better counter is the overall time taken to do your process ;-)

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

First, these two white papers:
http://www.microsoft.com/technet/pro.../anservog.mspx
http://www.microsoft.com/technet/pro.../ansvcspg.mspx

Second, configure your server to capture the system-wide processing log file
(run Analysis Manager, right-click on the server and look at the "Logging"
tab of the server properties. This allows you to gather statistics on when
and how long processing took.

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


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