Hi there,

I'm testing partitions in SSAS 2005. In previous version Analysis Services
2000, I have to set data slice to tell AS that data comes from as example
2005 november or 2005 december.

In SSAS 2005 I need to set only separate fact tables or define restricted
rows. This is OK and flexible, but I would like to analyze how many
partitions is participating in mdx query. In AS 2000 I have column
MolapPartitions in QueryLog. In SSAS 2005 I missed that column. Also, I have
not found any information about using partitions in PerfCounters or
Profiler.

Has anybode some information how to monitor using partitions in SSAS 2005.

Thank in advance
Ramunas Balukonis

SQL Profiler can now profile against Analysis Services. The progress
report begin and end events will tell you which partitions are being
read and the duration among other things.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1132821363.212207 (AT) loger (DOT) vpmarket.int>, ramblk2 (AT) hotmail (DOT) com
says...