Extended Events for SSAS

Cubes require frequent monitoring since their productivity decreases quite often (slowdowns during query building, processing time increment). To find out the reason of decrease, we need to monitor our system. For this, we use SQL Server Profiler. However, Microsoft is planning to exclude this SQL tracing tool in subsequent versions. The main disadvantage of the tool is resource intensity, and it should be run on a production server carefully, since it may cause a critical system productivity loss.

Thus, Extended Events is a general event-handling system for server systems. This system supports the correlation of data from SQL Server which allows getting SQL Server state events. Read More

Azure SSAS. Cubes in Clouds

Autumn of 2016 was full of events from Microsoft dedicated to analytics. In practice, the company began aggressive promotion of its predictive analytics and BI platform in the cloud. Finally, it has happened – Microsoft has released the preview of Azure SSAS Tabular. In fact, the company has transferred SSAS Tabular to the cloud. Therefore, SQL Server Analysis Enterprise Edition in cloud  supports DirectQuery, partitions, row-level security, bi-directional relationships, and has compatibility level 1200.

Read More