Cascade Skyline - with Microsoft Logo and Project Support header - author Brian Smith

In case you missed it - Improving cube build performance

In case you missed it - Improving cube build performance

  • Comments 1

I know a lot of you already read Chris's Project Programmability blog - but in case you haven't seen this posting from last week it has a great tip for using the SQL Server 2005 capability of guiding a query to be executed in a specific way without touching the query itself.  This uses sp_create_plan_guide.  See http://blogs.msdn.com/project_programmability/archive/2007/09/07/improve-the-performance-of-building-the-project-server-data-analysis-cube.aspx for full details.  For this particular customer scenario this made the difference between the query taking 17 hours and just minutes!

Technorati Tags: Project Server 2007

Leave a Comment
  • Please add 5 and 2 and type the answer here:
  • Post