SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Testing Microsoft SQL Server Analysis Services

colin-leonard avatar
colin-leonard
15 diapositives · 347 Views · Nov 18, 2014

Testing Microsoft SQL Server Analysis Services. Marius Dumitru Sivakumar Harinath Gonzalo Isaza Akshai Mirchandani. Outline. Introduction to Analysis Services Analysis Services Engine Architecture Current Testing Process & Challenges Approaches to improve testing.

Testing Microsoft SQL Server Analysis Services - slide 1
01 / 15Testing Microsoft SQL Server Analysis Services
1 / 17

Télécharger la présentation

Testing Microsoft SQL Server Analysis Services
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Testing Microsoft SQL Server Analysis Services Marius DumitruSivakumar HarinathGonzalo Isaza Akshai Mirchandani

  2. Outline • Introduction to Analysis Services • Analysis Services Engine Architecture • Current Testing Process & Challenges • Approaches to improve testing

  3. Introduction to Analysis Services • Multidimensional database • Multidimensional Expressions (MDX) queries • Server and client tools

  4. Query Execution Architecture Client Application MDX query Serialize results INFRASTRUCTURE Query Parser Data Mining Metadata Manager Populate axes Compute cell data Subcube operations Calculation Engine s FE Caches Formula Engine Partition Data Query s SE Caches SE Evaluation Engine Storage Engine Analysis Services

  5. Testing Analysis Services • Functionality Testing • Databases used • Exercise different components • Formula Engine (Calculations & rules) • Performance and Stress testing • Acceptance criteria & reporting

  6. Challenges • Functional testing • Most common type of queries • Recursive relationship definitions (P/C) complicate schema • Execution path evaluation may change easily • Size of query plan space • Many calculations may apply to a single cell • Size of cartesian product of dimensions • Combination of features

  7. Challenges • Performance testing • Wide variety of databases • Feature change has effect in other areas • Profiling issues

  8. Example query using IIF with member SalesIncludingAdPromotion as iif ([Sales Reason].[Sales Reason].currentmember is [Sales Reason].[Sales Reason].[Magazine Advertisement], [Measures].[Internet Sales Amount], [Measures].[Internet Extended Amount] + [Measures].[Internet Tax Amount]) select SalesIncludingAdPromotion on 0, [Customer].[Full Name].members on 1 from [Adventure Works] where [Customer].[Country-Region].&[United States]

  9. IIF(C, e1, e2) Naive Evaluation IIF(C, e1, e2) Eager Evaluation 15K σv is not null 1M 15K Apply Union 1M 5K Lookup 10K IIF CrossJoin σ C==true σ C==false 20K 30K 100 ½ M 100 1M 100 ½ M D1 D2 Apply D3 Apply C e1 e2 30K 20K e1 C e2 C

  10. Testing Enhancements • New tool (generate databases & queries) • Create db’s & Validate discovers with simple MDX queries • Different storage types • Combination of features

  11. Data from Mixed Sources Data from AS db Data from Rel db Same database with different storage modes. ROLAP HOLAP MOLAP Send same Query Compare Responses

  12. Testing Enhancements • New tool (generate databases & queries) • Create db’s & Validate discovers with simple MDX queries • Different storage types • Combination of features • Ability to influence execution path

  13. Block vs. cell by cell computation • SQL 2008: Execution path control

  14. Testing Enhancements • New tool (generate databases & queries) • Create db’s & Validate discovers with simple MDX queries • Different storage types • Combination of features • Ability to influence execution path • Databases with focused queries • Propose performance impact during upgrades

  15. Questions{gonzaloi,sivah,mariusd,akshaim} @microsoft.com