Set up SSAS (Analysis Services) on Denali

Set up SSAS (Analysis Services) on Denali

I have setup a virtual machine on Hiper-V to analyze the SQL Server Denali CTP3 bits. One of the “new” features I was interested on was the upgrade on the SSAS side. As probably most of you have been reading, there is a double path on the Analysis Services area, to go on the tabular or the OLAP model. To solve that it has been defined the BISM (Business Intelligence Semantic Model), you can find additional information ‘La biblioteca de PowerPivot’ from my SolidQ Colleagues. What I have found has really surprised me because you have to decide on the installation path (as you can see in the figure below) if you want to setup a tabular or a multidimensional instance. That means that the SSAS engine is totally different and you have to setup separate instances names even if you want to have both models in your company. (more…)

Wait stats information to Synchronous Bucketizer Target in Denali CTP1 with Extended Events

Following the article yesterday  (Know Where Your Query Spends Its Time), here is the code to send the wait stats information to a synchronous bucketizer; the obvious pros are that the structure is in memory, and you don’t need to stop the session to process the data; the cons are that you cannot reset the data read (unless you re-create the session); the other big con is that you cannot sum values in the columns (in the case of the wait_stats time is important). (more…)