MS SQL Server OLAP - Partitions in SSAS 2005

Author

Partitions in SSAS 2005

Ramunas Balukonis

2005-11-24, 3:23 am

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

Darren Gosbell

2005-11-24, 7:23 am

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@loger.vpmarket.int>, ramblk2@hotmail.com
says...
> 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
>
>
>

Sponsored Links