Management Data Warehouse
www.quontrasolutions.com
What is a Management Data Warehouse? System consisting of a one or more collectors (Performance Data Collector), a management server (MDW), and reports.
www.quontrasolutions.com
What is a Management Data Warehouse? Physical Warehouse
Data Warehouse
Building that consists of racks or aisles of products
Database consisting of tables of data and access functions
1.
Warehouse
1.
Database
2.
Racks
2.
Tables
3.
Lots of products
3.
Data records
4.
Forklifts for racking products
4.
SSIS
5.
And picking
5.
stored procedures/views
6.
Trucks for transporting To
6.
Flat files/Agent job, Sproc/SSIS
7.
And from warehouse
7.
Reports
www.quontrasolutions.com
What is it used for? •
Baselining
•
Performance Monitoring
•
Performance troubleshooting •
I/O
•
CPU
•
database growth
www.quontrasolutions.com
MDW components Schemas •
Core
•
Snapshots
•
Custom Snapshots
•
Sysutility (Utility Control Point)
Security Roles •
mdw_admin
•
mdw_reader (read-only view of reports – *msdb exception)
•
mdw_writer (collection set upload to MDW)
www.quontrasolutions.com
Data Collection Sets •
Disk Usage (collect and upload every 6 hours)
•
Server Activity (every 60 seconds, upload every 15 min)
•
Query Statistics (every 10 seconds, upload every 15 min)
•
Custom
www.quontrasolutions.com
Data Providers Performance counters DMV’s SQL Trace T-SQL
www.quontrasolutions.com
Miscellaneous •
How many servers? 100+
•
How much space? 400Mb/day/server
•
•
Editions? Enterprise, Data Center, *Standard Backward compatibility? No
Click icon to add picture
www.quontrasolutions.com
How does the data get into the warehouse? SSIS
www.quontrasolutions.com
Reports •
Management Data Warehouse Overview
•
Disk Usage
•
Query Statistics
•
Server Activity
Reports offer drill-down to additional reports/information
www.quontrasolutions.com
Demos 1.
Configure MDW
2.
Configure collectors
3.
MDW schema
4.
msdb
5.
SQL Agent - Jobs
6.
Integration Services - SSIS packages
7.
Task Manager
8.
Cache files
9.
Collector reports
10.
MDW Overview report
www.quontrasolutions.com
Thank you! Website •
www.systemental.com
•
www.leanprojectmanager.com
Blogs •
dean-o.blogspot.com
•
practicalhoshin.blogspot.com
Twitter •
twitter.com/deanwillson
Email •
dean@systemental.com
LinkedIn •
www.quontrasolutions.com
linkedin.com/in/deanwillson
Task Manager
www.quontrasolutions.com
Temporary Data Collector Cache
www.quontrasolutions.com
Disk Usage report
www.quontrasolutions.com
SSIS Packages
www.quontrasolutions.com
Hyper-V Server 2008
www.quontrasolutions.com
www.quontrasolutions.com
info@quontrasolutions.com
For More Details Contact us
Quontra Solutions Visit: http://Www.quontrasolutions.com Email: info@quontrasoluitons.com Call us: (404) 900 - 9988