Andreas Wolter • 4/9/2013

Tracing Analysis Services (SSAS) with Extended Events – Yes it works and this is how

This article provides a detailed tutorial on configuring Extended Events (XEvents) for SQL Server Analysis Services (SSAS), despite the lack of GUI support. It includes sample DDL code to create a session for capturing events like deadlocks, explains how to view active traces, and demonstrates analyzing collected data in Management Studio. The author emphasizes the performance benefits over SQL Profiler and references community benchmarks.

0 comments

#performance #Monitoring #SQL Server