Best practices for maximum performance and scalability gains for SQL Server workloads

We have worked with our colleagues in CSS to publish a KB article that lists recommended configuration and tuning options as well as necessary updates for SQL Server if you are running one of the newer versions of SQL Server on modern hardware. A typical configuration of this high performance workload environment comprises SQL Server…

0

Overcoming Performance limitations in ROLAP and PDW

Overview: The customer uses SSAS ROLAP partition model connect to PDW as data source. The customer wants to do a drill through action, and the ROLAP query generated by the drill through contains a few hundred GROUP BY clauses. The ROLAP query is requesting more data than the customer is asking for in the drill…