In case you missed it - Improving cube build performance

16 September 2007

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

Originally by BriSmith from Brian Smith’s Project Support WebLog on September 11, 2007, 10:16am

Popularity: 13% [?]

If you enjoyed this post, make sure you subscribe to my RSS feed!