introduction to management datawarehouse
TRANSCRIPT
Management Data Warehouse
www.quontrasolutions.com
System consisting of a one or more collectors (Performance Data Collector), a management server (MDW), and reports.
What is a Management Data Warehouse?
www.quontrasolutions.com
Physical Warehouse Data Warehouse
Database consisting of tables of data and access functions
1. Database
2. Tables
3. Data records
4. SSIS
5. stored procedures/views
6. Flat files/Agent job, Sproc/SSIS
7. Reports
Building that consists of racks or aisles of products
1. Warehouse
2. Racks
3. Lots of products
4. Forklifts for racking products
5. And picking
6. Trucks for transporting To
7. And from warehouse
What is a Management Data Warehouse?
www.quontrasolutions.com
• Baselining
• Performance Monitoring
• Performance troubleshooting• I/O• CPU• database growth
What is it used for?
www.quontrasolutions.com
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)
MDW components
www.quontrasolutions.com
• 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
Data Collection Sets
www.quontrasolutions.com
Performance counters
DMV’s
SQL Trace
T-SQL
Data Providers
www.quontrasolutions.com
Click icon to add picture
• How many servers? 100+
• How much space? 400Mb/day/server
• Editions? Enterprise, Data Center, *Standard
• Backward compatibility? No
Miscellaneous
www.quontrasolutions.com
SSIS
How does the data get into the warehouse?
www.quontrasolutions.com
• Management Data Warehouse Overview
• Disk Usage
• Query Statistics
• Server Activity
Reports offer drill-down to additional reports/information
Reports
www.quontrasolutions.com
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
Demos
www.quontrasolutions.com
Website• www.systemental.com
• www.leanprojectmanager.com
Blogs• dean-o.blogspot.com• practicalhoshin.blogspot.com
Twitter• twitter.com/deanwillson
Email• [email protected]
LinkedIn• linkedin.com/in/deanwillson
Thank you!
www.quontrasolutions.com
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
For More Details Contact us
Quontra Solutions
Visit: http://Www.quontrasolutions.com
Email: [email protected]
Call us: (404) 900 - 9988