Sept 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – 2005 – Analysis Services Query Performance Top 10 Best Practices

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
9 Comments

Analysis Services Query Performance Top 10 Best Practices

  1. Optimize cube and measure group design
  2. Define effective aggregations
  3. Use partitions
  4. Write efficient MDX
  5. Use the query engine cache efficiently
  6. Ensure flexible aggregations are available to answer queries.
  7. Tune memory usage
  8. Tune processor usage
  9. Scale up where possible
  10. Scale out when you can no longer scale up

Technet

Reference : Pinal Dave (https://blog.sqlauthority.com)

Best Practices, Database, SQL Documentation
Previous Post
SQLAuthority News – Download White Papers – Migration from MySQL, Oracle, Sybase, or Microsoft Access to Microsoft SQL Server
Next Post
SQL SERVER – Add Column With Default Column Constraint to Table

Related Posts

9 Comments. Leave new

  • Krishan
    March 21, 2008 7:33 pm

    Hi, I saw your site in google. its very fine.

    Please send me the Interview Questions Asked by the Companies of Sqlserver2000 and Sqlserver2005.

    Regards,
    Krishan
    Hyd

    Reply
  • bms
    April 20, 2008 1:21 am

    Hi..
    I M Glad To know About You Also From Ahemedabad,Gujarat
    Thanks For This Site
    I Knew About This Site just before
    7-8 days
    but From 1 day i daily read it

    Thanks For This Blog Site

    Reply
  • Devesh
    May 6, 2008 11:26 pm

    Can u help me about MDX ?
    How MDX acutlly use in Practical application..

    Reply
  • Sandeep
    August 22, 2008 10:50 pm

    Hi Pinal,

    I am facing following problem in SSAS and I’ll be really appreciate your guidance/suggestion/tips to resolve the same.

    I have created a multilingual application which reads some master data from Analysis Tool along with some calculated values. The data is dispayed in 3rd Party control i.e. Dundas Olap Control and Dundas Web Chart. I have written OLAP Translation for each of my language.

    It works well with languages like Spanish, Portugal, French, Chinese. However for Italian and Korean it returns me empty cells. The strange thing is that it shows appropriate data in OLAP integrated browser and Dundas Olap Control for all langauges including Italian and Korean but when I explicitly fire MDX by changing connection string (Locale Identifier) it returns me empty values.

    I have no clue where the issue is. I am running SQL Server Enterprise Edition with Service Pack 2.

    Thank You!

    Rgds,
    Sandeep

    Reply
  • Ed
    December 17, 2008 8:11 pm

    Hi Pinal,
    Do you know if it is possible to use a cube as a datasource in a Coldfusion application and query it using MDX?
    Thanks

    Reply
  • Al
    April 1, 2009 10:52 pm

    Pinal,
    Any updates on Ed’s questions. I am wondering the same thing?

    Reply
  • Jayesh l
    March 23, 2010 12:36 am

    hi pinal,

    i want to learn SSAS services and want to implement it in my project so can help me out for finding the best solution..
    can you please give me some links and tutorial though i can learn SSAS with Example

    thanks

    from
    Jayesh L Lolariya

    Reply
  • Inder
    October 22, 2010 8:23 pm

    Hi , I am have recently started working on ssas,,
    and i got an assignment to do some changes in ssis package i did it , now my senior is asking me to how the changes are going on , in the cube, he wants me to see the changes in the cube, I have no clue of what he means,,I dont understand what he wants me to do. If any one could help me out , p

    PLZ REPLY BACK, you can save my job,,,

    Reply
  • Inder
    October 22, 2010 8:31 pm

    Hi Pinal and everyone,,

    I got this assignment which required me to do some modifications to the existing ssis package,, i have done that , but now my senior asks me how the changes in the cube are going on, I have no Idea abt SSAS, I did not understand by what he means ,,, Please help me out with this problem and tell me how to see the changes in the cube and what he means by that, I am totally new,,I appoligise if these questions sound stupid to u,, but gotta ask to get help on that,,,

    Thanks a millions

    Reply

Leave a Reply

Idera

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 13 SQL Server database books and 53 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,600 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long term multi-channel campaigns to drive leads for their sales pipeline.

Comprehensive Database Performance Health Check

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

SQL Server Performance Tuning Practical Workshop

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.