Using xEvents to monitor Azure Analysis Services

%3CLINGO-SUB%20id%3D%22lingo-sub-60742%22%20slang%3D%22en-US%22%3EUsing%20xEvents%20to%20monitor%20Azure%20Analysis%20Services%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-60742%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20addition%20to%20providing%20BI%20queries%20at%20the%20speed%20of%20thought%20and%20a%20user%20friendly%20BI%20semantic%20model%2C%20Azure%20Analysis%20Services%20supports%20many%20manageability%20features.%20One%20such%20feature%20is%20a%20rich%20set%20of%20Extended%20Events%20(xEvents)%20which%20can%20be%20used%20for%20scenarios%20ranging%20from%20trouble%20shooting%20and%20diagnostics%20to%20in%20depth%20auditing%20and%20usage%20analysis.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20SQL%20Server%20Management%20Studio%20(SSMS)%20to%20configure%20a%20xEvents%20for%20Azure%20Analysis%20Services.%20Today%2C%20you%20can%20only%20configure%20Azure%20Analysis%20services%20to%20log%20to%20a%20stream%20or%20ring%20buffer%20and%20not%20to%20a%20file.%20In%20some%20cases%2C%20you%20may%20want%20to%20log%20events%20for%20offline%20analysis%20or%20to%20retain%20historically.%20We%20have%20provided%20an%20example%20of%20using%20the%20Tabular%20Object%20Modeling%20APIs%20to%20create%20an%20xEvents%20session%20and%20logging%20the%20data%20to%20disk%20and%20a%20richer%20sample%20to%20trace%20to%20a%20database%20with%20a%20windows%20service.%20The%20xEvents%20Logging%20for%20Azure%20Analysis%20Services%20sample%20and%20ASTrace%20samples%20are%20available%20on%20GitHub%20at%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2FAnalysis-Services%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FMicrosoft%2FAnalysis-Services%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20624px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F12989i1D681D723C670DA6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22azureanalysis.png%22%20title%3D%22azureanalysis.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERead%20about%20it%20on%20the%20Azure%20blog.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-60742%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Community Manager

In addition to providing BI queries at the speed of thought and a user friendly BI semantic model, Azure Analysis Services supports many manageability features. One such feature is a rich set of Extended Events (xEvents) which can be used for scenarios ranging from trouble shooting and diagnostics to in depth auditing and usage analysis.

 

You can use SQL Server Management Studio (SSMS) to configure a xEvents for Azure Analysis Services. Today, you can only configure Azure Analysis services to log to a stream or ring buffer and not to a file. In some cases, you may want to log events for offline analysis or to retain historically. We have provided an example of using the Tabular Object Modeling APIs to create an xEvents session and logging the data to disk and a richer sample to trace to a database with a windows service. The xEvents Logging for Azure Analysis Services sample and ASTrace samples are available on GitHub at https://github.com/Microsoft/Analysis-Services.

 

azureanalysis.png

 

Read about it on the Azure blog.

0 Replies