SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Analysis Services Performance Optimization Tips

Over the last few weeks I have focused most of my blog energy into writing a couple articles.  So I wrote about something I was really interested in learning more about myself.  The result was three articles on performance tuning Analysis Services.  These articles not only explain the benefit to of doing each but also give step by step instructions so you can build it yourself in your environment.  You can find these articles at www.bidn.com (Business Intelligence Developer Network).

Analysis Services Partitions

Analysis Services Aggregations

Analysis Services Usage-Based Optimization (UBO)

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).


Posted by Glenn Berry on 29 December 2009

Writing about something always forces you to lerrn more about something, which is why I like to do it. Good job!

Posted by Ayyappan on 4 January 2010

writing articles is an art. I love people those who are writing something for community. keep it up. may god gives you energy to write more.


Leave a Comment

Please register or log in to leave a comment.