How to check if SSAS Partitions are running in parallel or not using SQL Profiler?

2
votes

I am situation where I have to check and confirm whether SSAS partitions queries are running parallel or not while processing the SSAS cube using SSIS job. SSIS job/package using 'Analysis Services Processing Task' to process cube by selecting each object(dimensions and partitions) in it instead of selecting direct SSAS DB.

Can any one please guide how to check parallelism using sql profiler?

Also if anyone can point out why cube processing using above way is taking longer than the cube processing by SSIS job in which 'Analysis Services Processing Task' selecting ssas db name directly.

please help with any comments/ suggestions.

Many Thanks

Regards,

Update: My end db from which partitions will fetch the data is Oracle

2
oraclessisssasmsbisql-server-profiler
Is the issue solved? – Yahfoufi

2 Answers

1
votes

I think there is an easier way than using SQL Profiler, you can benefit from the amazing stored procedure sp_whoisactive to check what are the current query running on the server (Data Source SQL Database Engine) while processing the Analysis Services Processing Task.

Just download the stored procedure and create it on your master database.

Hint: In SQL Server Management Studio, go to data source properties and check the maximum allowed connections property, since it may prevent queries parallel execution

0
votes

If you are looking for an answer using SQL Profiler, you can simply create a trace to monitor the SQL Server that contains the data sources used by partitions. And while the partitions are processed if many SQL queries are executed in parallel then parallelism is achieved.

If you are new to SQL Profiler you can refer to the following links to learn how to monitor only T-SQL commands:

But if you are looking for a simpler solution, then the other answer is what you are looking for.