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?
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.
Select * from $System.discover_object_memory_usage /** This query reports on memory consumption by object.
https://msdn.microsoft.com/pl-pl/library/hh230820(v=sql.110).aspx
0
0