Transcript Gordon McKenna - MVP System Center Operations Manager - Inframon Ltd Sean Roberts – Head of Product Development – Inframon Ltd.

Gordon McKenna - MVP System Center Operations Manager - Inframon Ltd
Sean Roberts – Head of Product Development – Inframon Ltd
Agenda
Introduction
Role Play
The IT Iceberg Effect
Defining a Performance Framework
The SLA Evolution
Operations Manager Report Demo
Dashboards Overview
Creating a CIO Dashboard Demo in SQL
Reporting Services 2008 R2
Questions
About Inframon
“One of the best System Center Partners in the
world” – Ryan O’Hara, Director of System Center
Marketing, Microsoft, November 2009
System Center Specialists
EMEA based System Center consultancy,
solutions and training
The only two System Center Operations
Manager MVPs in the UK…
Role Play
“Us” versus “Them”
IT v Business World
Understanding the Problem
• Constantly under attack from
the business
• Variable goals, measures and
targets
• Constantly fire fighting the latest
adhoc “problem”
• Performs a lot of work that adds
value but is unseen by the
business
• Feels undervalued and over
worked.
• Finances IT
• Feels that money is spent
but systems are down or slow
• Downtime costs HIM money
• Has no visibility into IT
performance
• Has to constantly prod IT for
information
• Has a poor perception of IT
An Analysis of Issues
Lack of visibility &
transparency
No agreed upon
framework for
acceptable
performance
IT Blackhole effect
Cannot measure,
scorecard or trend
Performance
Reactive Problem
Solving
Cannot identify
poor performing
apps
Poor planning &
investment
decision
Microsoft Operations Manager
SLA Evolution
Retrospective
Calculated & Derived
Availability Report
(MOM 2005)
Basic
Near Real Time
Real Time
Health Model Availability
and Performance
(OpsMgr 2007)
Service Level Tracking
(OpsMgr 2007 R2)
Standardised
Dynamic
The IT Iceberg Effect
• Value – Does this service deliver me tangible
value and help me to execute my function?
Value
Costs
Availability
Performance
• Costs – Are costs realistic, transparent and
controlled?
Processes
People
Solutions
• Availability – Is this service available when I
need it. Downtime costs me money.
• Performance – We need an agreed upon
framework for acceptable performance of the
technology and related support processes
Service Level Agreements
Constructing our SLA
Hours of Operation (9-5/24-7)
Determination of Scope (Application A & B)
Definition of Measurable Items
Availability (Uptime)
Performance (Response Time)
Acceptable Targets
Availability>99.5%
Performance (Response Time)
Business Process
Consumers
Frequency
Delivery Method
Operations Manager Reporting
Finding SLA Information
Service Level Tracking
Standard SLA Reporting
Service Level Dashboard V2
Delivery Mechanism
Adhoc
Export to XLS/PDF etc
Scheduled Delivery
Email
Network Share
Publishing to Sharepoint
Operations Manager 2007 Reporting
Getting SLA Information
OpsMgr
End to End Enterprise Reporting Framework Self
Service Portal
Default
Reports
IT Operators
Custom
Reports
SSRS 2008 R2
Data Warehouse
OLAP
Cube
Performance
Point
SharePoint 2007
IT Analysts
Analysis
IT Managers
Service Level
Dashboard V2
Executives
Building a CIO Scorecard in SSRS
Collect Data from Operations Manager DW
Report Builder 3.0
Report upon
Alerts
Availability
Key Metrics
Sources data from
SQL
Cubes
Microsoft Operations Manager DW
Live Data Warehouse
Multiple Aggregates
Raw
Hourly
Daily
Choosing the right aggregate; Gotchya!
Report Builder 3.0 (November CTP)
ClickOnce application
No longer requires report models (Since 2.0)
Runs reports locally
Tablix Reports
Includes Maps… that’s right MAPS!!!!
SSRS v PerformancePoint
•Highly Customizable Format
• Constrained by web parts
• Exports to multiple formats
(PDF, tiff, word, html, mhtml,
excel, csv)
• Scheduled delivery channels;
email, file share to snapshots
• Exports to PowerPoint &
Excel
• No scheduled delivery
• Uses SSAS and SSRS
• Requires more skills in SQL or
SSAS
• No slice and dice functionality
•Has maps and dials
• Has slice and dice
• Low learning curve once cube
is configured
Service Level Objectives
Managed Entities (State)
Managed Entities (Collection)
Fact Tables
Creating a CIO Dashboard in SQL 2008 R2
OpsMgr
End to End Enterprise Reporting Framework Self
Service Portal
Default
Reports
IT Operators
Custom
Reports
SSRS 2008 R2
Data Warehouse
OLAP
Cube
Performance
Point
SharePoint 2007
IT Analysts
Analysis
IT Managers
Service Level
Dashboard V2
Executives
Conclusion
Importance of SLA Reporting
Gathering SLA Information from Operations
Manager
Defining the Operational Reporting Framework
Creating CIO Dashboards
Q&A
Resources for IT Professionals
www.microsoft.com/teched
Tech·Talks
Live Simulcasts
Tech·Ed Bloggers
Virtual Labs
http://microsoft.com/technet
Evaluation licenses, pre-released
products, and MORE!
Complete an evaluation
on CommNet and enter to
win an Xbox 360 Elite!
© 2008 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should
not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS,
IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.