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: 523
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
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.
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