Several reports are based on the same SQL Server Analysis Services (SSAS) cube. Each report has several datasets defined with complex Multidimensional Expressions (MDX) queries. The company maintains separate development, test and production environments.
The reports are running slowly. You plan to analyze report performance. You have the following requirements:
Monitor query statistics on the production server with as little server overhead as possible.
Gather, replay, and analyze statistics on the test server with as little administrative effort as possible.
Identify the longest-running queries on both servers.
Document statistics on disk reads on both servers.
You need to gather statistics and meet the requirements.
Which features should you use?
To answer, drag the appropriate feature or features to the correct location or locations in the answer area. (Use only features that apply.)
Select and Place:
