Back to Declic Consulting web site.. TechDays 2008: Optimisation Performances Analysis Services 2005

TechDays 2008: Optimisation Performances Analysis Services 2005

by patricet28 18. February 2008 00:26

Many thanks to those of you who attended my presentation at TechDays 2008 in Paris, earlier this week.

As promised, here are the scripts that I used during my demos, as well as the Powerpoint slides themselves -- you'll need to read French to get anything useful out of them :-)

The Techdays.zip archive contains the following files:

Optimisation Performances AS2005.pptx: the Powerpoint presentation in French
Techdays-FE.xmla: the XMLA script to recreate my demo database
TechDays-FE.mdx: the script that contains the queries I ran against the techdays-FE cube
TechdaysQueries.sql: the SQL queries to determine the time spent in the Storage engine vs. the formula engine.

You'll need the AdventureWorksDW database (http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=8392) to be able to run the FE and SE queries I used in my demo.

Good luck and feel free to drop me a message if you have any questions!

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Comments

Add comment


(Will show your Gravatar icon)  

  Country flag

biuquote
  • Comment
  • Preview
Loading



Powered by BlogEngine.NET 1.4.5.0
Theme by Mads Kristensen

TextBox

Tag cloud

RecentPosts