1 / 19

Analysis Services for the DBA

Join Mark Stacey, founder of Pragmatic Works South Africa and BIDN Johannesburg chapter leader, for an in-depth analysis of SQL Server Analysis Services (SSAS). Learn how SSAS enhances query performance, supports operational analysis, and optimizes management studio usage. This presentation covers essential topics such as partition processing, backup strategies, and storage considerations. Gain practical insights into managing large databases, optimizing queries, and utilizing XMLA commands. Perfect for DBAs and developers seeking to leverage the power of SSAS in their environments.

fauve
Télécharger la présentation

Analysis Services for the DBA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Analysis Services for the DBA Mark Stacey

  2. Mark Stacey • Founded Pragmatic Works South Africa • Started BIDN Johannesburg chapter • Frequent presenter at MS User Groups • Author of “Sharepoint 2010 BI”

  3. Agenda • What *is* Analysis Services? • How does Analysis Services help queries? • Analysis Services in Management Studio • Operational Analysis Services • Backups • Processing Partitions – manually and scheduled • Storage considerations • Archiving/Merging Partitions • Usage based optimisation • Data Management Views • DBAs and Developers – a happy place…

  4. ? What *is* Analysis Services

  5. SQL Server Instance MSOLAP

  6. Large DBs, slow running queries • SUM, MAX, GROUP BY • Billions of rows • Summary tables?

  7. Why SSAS Faster queries Drag and drop reports Centralize logic

  8. Cubes Tires Products Measure groups Dimensions Trek Bikes 2005 Q1 Jan Time Feb Mar Qty Sold Cost Sales Measures

  9. ? How does Analysis Services help queries? Excel Demo

  10. Operational SSAS – Management Studio Practical

  11. Management Studio • Backups • Processing Partitions – manually and scheduled • Storage considerations • Archiving/Merging Partitions • Usage based optimisation • XMLA – the next step

  12. Data Management Views Practical

  13. Data Management Views • $system.discover_object_activity • $system.discover_partition_stat • $system.discover_object_memory_usage • $system.DISCOVER_Commands • $system.discover_command_objects • $SYSTEM.DISCOVER_PERFORMANCE_COUNTERS • SYSTEMRESTRICTSCHEMA

  14. DBAs vs Developers Discussion

  15. Environments

  16. BIDS • Importing a database • Deployment Wizard

  17. Questions? User Group http://www.bidn.com/ Blog http://www.bidn.com/people/MarkGStacey Twitter @MarkGStacey

More Related