SQL SERVER – BI Quiz – Troubleshooting Cube Performance

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)

About these ads

3 thoughts on “SQL SERVER – BI Quiz – Troubleshooting Cube Performance

  1. 1.adding lot’s of attributes to a dimension will bloat your cube and slow things down
    2. Check if the relationships between attributes in a dimesnion are clearly defined.
    3. Are there too many, many to many relationships in a dimension.
    4. Run SQL Profiler for SSAS and check the usage of cache and performance of the MDX queries.
    5. Is the cube partitioned, is the data in the cube at a stgae where it can be partitioned.

  2. Pingback: SQLAuthority News – BI Quiz Question – How to Optimize Cube? – Hints Journey to SQLAuthority

  3. Pingback: SQL SERVER – BI Quiz Hint – Performance Tuning Cubes – Hints | Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s