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?

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?

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 0

Your email address will not be published. Required fields are marked *