Bernd Schneider
Technical Solution Professional - BI
Microsoft Schweiz
Solution Overview and Architecture
Collect the Source Data
Operations Manager Data Warehouse
SQL Server Integration Services
Build the Cube
SQL Server Analysis Services
Put it all Together
SharePoint Server 2007 & PerformancePoint
Server 2007
Solution Walk-Through & Creating SCOM
Dashboards
Integrated (balanced) view of IT Performance
Roll up disparate metrics in a single scorecard –
Server capacity, Transactions, SLA measurement
Ad-hoc analytics
Help determine root cause for usage spikes,
application downtime
Predictive analytics
What will my capacity needs look like next year?
Leverages existing infrastructure
SQL Server, Operations Manager, SharePoint, Office
Monitor State Detail
Daily Trends
Availability Metrics
Performance Counters
Hourly Data
DELIVERY
SharePoint Server
Reports
Excel
Dashboards Workbooks
Analytic
Views
Scorecards
Plans
END USER TOOLS & PERFORMANCE MANAGEMENT APPS
Excel
PerformancePoint Server
BI PLATFORM
SQL Server
Reporting Services
SQL Server
Analysis Services
SQL Server DBMS
SQL Server Integration Services
DELIVERY
SharePoint Server
Reports
Excel
Dashboards Workbooks
Analytic
Views
Scorecards
Plans
END USER TOOLS & PERFORMANCE MANAGEMENT APPS
Excel
PerformancePoint Server
BI PLATFORM
SQL Server
Reporting Services
SQL Server
Analysis Services
SQL Server DBMS
SQL Server Integration Services
“Sandbox” environment for business users to:
Formally integrate data from other systems
View data models that reflect how the business side
sees the world (custom hierarchies, new groupings,
friendly naming, calculations)
Consume “temporal” or one-off data models
Provides an ad-hoc experience optimized for enduser query performance, trending and drill-down
analysis
Ad-hoc queries and frequent monitoring of KPIs
will not load down the transactional database
Interactive dashboards in SharePoint
Linked filters, scorecards, and analytics (keep
everything in-context)
Scorecards
Aggregate disparate metrics on a single scorecard, or
“balanced scorecard”
Measure and monitor data from virtually any tabular
(Excel, ODBC) or multi-dimensional data source
(SSAS)
Flexible, user-defined KPI targets, thresholds, and
scoring
Trend analysis
Facts & Dimensions
Alerts
Events
Entities
Performance
State
Data Source View
UDM structure
Measures
Dimensions
Calculations
Diagrams of star schemas – state cube, perf
cube
State
Amount of time that monitors are in a particular state,
and percent of total
Performance Counters
Average, minimum, and
maximum performance
counter values
Standard deviation
Hierarchy and attributes for availability, health, and
performance monitors
• Top Level Group
• • Type
• • • Path
• • • • Entity Name
• • • • • Monitor Name
Hierarchy and attributes for entity performance
counters (% free space, CPU, etc.)
• Top Level Group
• • Type
• • • Path
• • • • Object Name
• • • • • Instance Name
• • • • • • Counter Name
Monitor states, grouped by up/down time. Default
monitor grouping may be re-configured with a T-SQL
CASE statement.
• Up Down Key
• • State Description
Calendar dates and hours of day, with separate
attributes for time-folded analysis (values by hour for
the past week, for example)
• Date by Month (Year, Quarter, Month, Date)
• Date by Week (Year, Week, Date)
• Time (Hours, in 12 hour or 24 hour format)
A dimension that contains dynamic, time-based
calculations
•
•
•
•
•
•
Month-to-date
Quarter-to-date
Year-to-date
Prior Period
Year-to-date, Prior Year
Percentage change
Navigation through SCOM Dashboards
Dashboard Designer walkthrough
Create SCOM Dashboard
Datasource
KPI „Availability”
KPI „Disk free space”
Scorecard and Objective KPI
Analytic Grid „Performance Counter“
Analytic Chart „Disk free space trend line“
Dashboard Deployment
We have…
Discussed the need for IT Operations scorecards,
dashboards, analytics
Discussed building an Analysis Services cube
Created Key Performance Indicators (KPIs),
scorecards, dashboards, and analytic reports
Data Mining Add-In for Excel
Event correlation!
Data-driven diagrams with Visio
Show KPI status in a topology diagram
Predictive trend lines with PerformancePoint
Trend Charts
More…
SQL Server Datawarehouse Overview
http://technet.microsoft.com/en-gb/sqlserver/dd421879.aspx
PerformancePoint Web
http://www.microsoft.com/business/performancepoint/
SCOM/PPS Whitepaper & Samples
http://www.microsoft.com/business/performancepoint/downloads/defaul
t.aspx
Operations Manager Report Guide
http://blogs.technet.com/momteam/archive/2008/02/26/operationsmanager-report-authoring-guide.aspx
check out these websites, blogs & more!
Presentations
TechDays: www.techdays.ch
MSDN Events: http://www.microsoft.com/switzerland/msdn/de/presentationfinder.mspx
MSDN Webcasts: http://www.microsoft.com/switzerland/msdn/de/finder/default.mspx
MSDN Events
MSDN Events: http://www.microsoft.com/switzerland/msdn/de/events/default.mspx
Save the date: Tech•Ed 2009 Europe, 9-13 November 2009, Berlin
MSDN Flash (our by weekly newsletter)
Subscribe: http://www.microsoft.com/switzerland/msdn/de/flash.mspx
MSDN Team Blog
RSS: http://blogs.msdn.com/swiss_dpe_team/Default.aspx
Developer User Groups & Communities
Mobile Devices: http://www.pocketpc.ch/
Microsoft Solutions User Group Switzerland: www.msugs.ch
.NET Managed User Group of Switzerland: www.dotmugs.ch
FoxPro User Group Switzerland: www.fugs.ch
check out these websites, blogs & more!
Presentations
TechDays: www.techdays.ch
TechNet Events
TechNet Events: http://technet.microsoft.com/de-ch/bb291010.aspx
Save the date: Tech•Ed 2009 Europe, 9-13 November 2009, Berlin
TechNet Flash (our by weekly newsletter)
Subscribe: http://technet.microsoft.com/de-ch/bb898852.aspx
Schweizer IT Professional und TechNet Blog
RSS: http://blogs.technet.com/chitpro-de/
IT Professional User Groups & Communities
SwissITPro User Group: www.swissitpro.ch
NT Anwendergruppe Schweiz: www.nt-ag.ch
PASS (Professional Association for SQL Server): www.sqlpass.ch
7. – 8. April 2010
Congress Center Basel
Premium Sponsoring Partners
Classic Sponsoring Partners
Media Partner