Any Advice on Monitoring Performance of Processing Cubes in AS2000

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 wha
t
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@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> 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.|||First, these two white papers:
http://www.microsoft.com/technet/pr...n/anservog.mspx
http://www.microsoft.com/technet/pr...n/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@.online.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@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> 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.