SQL SERVER – BI Quiz – Troubleshooting Cube Performance

Posted by pinaldave on SQL Authority See other posts from SQL Authority or by pinaldave
Published on Mon, 06 Jun 2011 01:30:22 +0000 Indexed on 2011/06/20 16:29 UTC
Read the original article Hit count: 486

My friend Jacob Sebastian runs SQL BI Quiz competition. Where there are 30 different questions on each day of the month. Winners get opportunity to participate in this Quiz, learn something new and win great awards.

Working with huge data is very common when it is about Data Warehousing. It is necessary to create Cubes on the data to make it meaningful and consumable. There are cases when retrieving the data from cube takes lots of the time.

Let us assume that your cube is returning you data very quickly. Suddenly on one day it is returning the data very slowly. What are the three things will you in order to diagnose this. After diagnose what you will do to resolve performance issue.

Participate in my question over here

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Filed under: Business Intelligence, Pinal Dave, PostADay, Readers Question, SQL, SQL Authority, SQL Performance, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology

© SQL Authority or respective owner

Related posts about Business Intelligence

Related posts about Pinal Dave