PrepAway - Latest Free Exam Questions & Answers

You need to ascertain the memory consumed by each objec…

You are working with multiple tabular models deployed on a single SQL Server Analysis Services (SSAS) instance.
You need to ascertain the memory consumed by each object in the SSAS instance.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Use the $System.discover_object_memory_usage dynamic management view.

B.
Use SQL Server Profiler to review session events for active sessions.

C.
Use the Usage Based Optimization wizard to design appropriate aggregations.

D.
Use the Performance Counter group named Processing.


Leave a Reply