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 shou

The $System.discover_object_memory_usage DMV is specifically designed to return the amount of memory allocated to each object within an SSAS instance, making it the precise and direct tool for this requirement. Querying this view via XMLA or DAX Studio returns a row per object with its allocated and used memory metrics.

The Usage Based Optimization wizard analyzes existing query logs to design partition aggregations for performance improvement, not to report memory consumption.

SQL Server Profiler captures trace events for active sessions such as query start and end, but does not expose per-object memory allocation data for SSAS objects.

The Processing performance counter group measures throughput and activity during processing operations and does not track memory consumption by individual SSAS objects.