Management & Governance of Azure Analysis Services Instance using DMV
Credit : Microsoft Learning

Management & Governance of Azure Analysis Services Instance using DMV

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.

?https://docs.microsoft.com/en-us/analysis-services/instances/use-dynamic-management-views-dmvs-to-monitor-analysis-services?view=asallproducts-allversions#examples-and-scenarios?

A Screen-Shot of Power BI Report for Azure Analysis Services Governance

?In case anyone need detailed overview such analytical solutions please DM me.

要查看或添加评论,请登录

Sujeet Singh的更多文章

社区洞察