Management & Governance of Azure Analysis Services Instance using DMV
Sujeet Singh
Delivering Data Analytics, Gen AI, Business Intelligence and Cloud Solutions | Microsoft Certified Azure Data Architect and Expert - Data Management
While working on designing data semantic layer , we need to have a management report or toolkit where we can monitor all the semantic entities and profiles. Azure Analysis Services is a basic sematic layer serving as optimized & efficient entity to Power BI and Excel users for reporting and data visualization.?I have been designing a lot of client oriented Modern BI data platforms in Azure cloud and recommended Azure Analysis Services.?
Analysis Services Dynamic Management Views (DMVs) are queries that return information about model objects, server operations, and server health. The query, based on SQL, is an interface to?schema?row-sets. Schema row-sets are prescribed tables that contain information about Analysis Services objects and server state, including database schema, active sessions, connections, commands, and jobs that are executing on the server. DMVs are very beneficial to query system details of analysis services. I have designed a Power BI report which provides a complete list of all the cube models deployed on the server , their memory usage , sessions and metadata as well. These statics helps the IT & Administration .?
Microsoft has a detailed over view of DMVs and syntax to write queries and fetch data.
?In case anyone need detailed overview such analytical solutions please DM me.