PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. The instance contains cubes that use the HOLAP storage mode. The retrieval of data from the cubes is slow. You need to monitor the frequency with which the users access a member of each cell in a cube in System Monitor.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
In the Storage Engine Queries object, monitor the Current measure group queries counter.

B.
In the Storage Engine Queries object, monitor the Current dimension queries counter.

C.
In the Connection object, monitor the Current user sessions counter.

D.
In the Connection object, monitor the Current connection counter.


Leave a Reply