Any Advice on Monitoring Performance of Processing Cubes in AS2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Al - 13 Feb 2006 17:11 GMT

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.

Reply to this Message

Jéjé - 14 Feb 2006 13:57 GMT

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 ;-)

> Hi,
>
[quoted text clipped - 9 lines]
>
> Thanks in advance.

Reply to this Message

Dave Wickert [MSFT] - 14 Feb 2006 20:04 GMT

First, these two white papers:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/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.

Signature

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.

> Hi,
>
[quoted text clipped - 9 lines]
>
> Thanks in advance.

Reply to this Message