Enterprise Capability Maturity with SentryOne

1. Enterprise Capability Maturity with SentryOne

2. http://SentryOne.com/BookADemo The One Platform for Physical, Virtual, and Cloud Performance. SentryOne™ empowers Microsoft data professionals to monitor, diagnose, and optimize performance across physical, virtual, and cloud resources. The SentryOne platform delivers seamless integration for all of our solutions, enabling users to determine the true cause of performance issues, and reduce consumption and infrastructure costs.

3. Just Announced!

4. New SentryOne Portfolio +

5. Free Resources The One Platform for Physical, Virtual, and Cloud Performance. Free e-books In these books, you will find useful, hand-picked articles that will help give insight into some of your most vexing performance problems. These articles were written by several of the SQL Server industry's leading experts, including Aaron Bertrand, Paul White, Paul Randal, Jonathan Kehayias, Erin Stellato, Glenn Berry, and Joe Sack. http://www.sentryone.com/ebooks/ Websites SQLPerformance.com provides innovative and practical solutions for improving SQL Server performance. SentryOne.com/Resources offers an inside look into the world of SentryOne with videos on query tuning and product demos, white papers, ebooks, and tech briefs. Blogs.SentryOne.com is where you can find all of our team members’ blogs as well as important information about the latest updates to SentryOne software, SQL Server and server performance issues.

6. Your Presenter • Kevin Kline • Principal Program Manager, SentryOne • Microsoft Data Platform MVP since 2003 • Contact Info • Twitter : @Kekline • Email : KKline@SentryOne.com • Blog : http://blogs.SentryOne.com/author/kevinkline/ • LinkedIn : https://www.linkedin.com/in/kekline/

7. What is the Capability Maturity Model?

10. Information Mgt Maturity Model Level 4 What level are you? Value Level 3 • IT as strategic business partner • IT and business metric linkage • IT/business collaboration improves business process • Real-time infrastructure • Business planning Service Level 2 • IT as a service provider • Define services, classes, pricing • Understand costs • Guarantee SLAs • Monitor and report service availability • Capacity mgt Proactive Level 1 • Analyze trends • Set thresholds • Predict problems • Monitor end-user response time • Automate • Mature problem, configuration, change, asset and performance mgt processes Reactive Level 0 • Fight fires • Inventory • Desktop swdistribution • Initiate problem mgtprocess • Alert and event mgt • Monitor component availability Chaotic • Ad hoc • Undocumented • Unpredictable • Multiple help desks • Minimal IToperations • User call notification Manage IT as a Business Service and Account Management Service Delivery Process Engineering Operational Process Engineering Tool Leverage

11. CMMI – 5 Maturity Levels Prescriptive Analytics Process performance continually improved through incremental and innovative technological improvements. Level 5 Optimizing Advisory Conditions Level 4 Quantitatively Managed Processes are controlled using statistical and other quantitative techniques. Process Maturity Benchmarks Baselines Level 3 Processes are well characterized and understood. Processes, standards, procedures, tools, etc. are defined at the organizational (Organization X )level. Proactive. Defined Dashboard Level 2 Managed Processes are planned, documented, performed, monitored, and controlled at the project level. Often reactive. Level 1 Initial Processes are unpredictable, poorly controlled, reactive.

12. MDO Methodology | Monitor. Diagnose. Optimize. Go from reactive database firefighter to proactive performance tuner and trusted advisor. M D O Proactive Optimize Diagnose 5 Enhancements Advisory Conditions Baselines Event chains Fragmentation analysis 4 Business Requirements Compliance reporting Cloud/Power BI content pack SQL Server data mining • 3 • Specific Performance • Dashboard • Top SQL • VMware/Hyper-V • SSAS • Query analysis ( Plan Explorer) • 2 • General Performance • Dashboard • Calendar • Alerts • Top SQL Monitor • 1 • Visibility • Dashboard • Standard reports • Outlook-style event calendar Reactive

13. Optimizing Defined Over reliance on experience of good people – when they go, the process Managed goes. “Individual Heroics.” Behaviors Maturity Level Process Characteristics Behaviors Focus on "fire prevention"; Focus is on continuous quantitative improvement improvement anticipated and desired, and impacts assessed. Greater sense of teamwork and inter- Process is measured and controlled Quantitatively Managed dependencies Reliance on defined process. People understand, support and follow the process. Process is characterized for the organization and is proactive Process is characterized for projects and is often reactive Focus on "fire fighting"; Process is unpredictable, poorly controlled, and reactive Initial effectiveness low – frustration high.

14. Summary • Download Plan Explorer! • http://sentryone.com/plan-explorer • Like our products? • Please consider giving us a referral and/or evaluation on TrustRadius! • Let’s connect! • Facebook, LinkedIn, Twitter at KEKLINE. Mature enterprise IT organizations exhibit certain qualities and behaviors. The CMMI provides a roadmap to enterprise maturity. SentryOne can ease the pain and make it easier to mature. Learn more about CMMI at http://cmmiinstitute.com/