New Zealand's new Copyright Law presumes 'Guilt Upon Accusation' and will Cut Off Internet Connections without a trial. is against this unjust law - help us

A Space for All Things .NET Related

Management of data warehouse (performance)

By James Hippolite, in , posted: 6-Dec-2008 17:17

Management of data warehouse (performance)
  • Greg Low (again)
  • Show
    • Definition of the new tools and features
    • Demonstrations
  • Flow
    • Explanation of how the features work
    • Demonstration of the features components
  • Know and Go
    • Internals and architecture
    • Planning and Implementation
 SQL Sever 2008 Performance Monitoring Tools
  • Data Collector
  • Management Data Warehouse
  • Performance and Configuration* Reports
  • Activity Monitor
  • Graphical Showplan*
  • SQL Profiler*
  • Dynamic Management Views*
  • Resource Governor (Enterprise Only)
  • XEvents
  • Database Engine Tuning Advisor (Enterprise Only)*
 *=Enhanced Feature Take a snapshot (copy) of data
  • from system data management views
  • into a static copy
  • e.g. sys.dm_exec_sessions
 Activity Monitor (is really sweet)
  • Processes
  • Resource Waits
  • Data File I/O
  • Recent Expensive Queries
 Data Collection and Evaluation Components
  • SQL2K8 Engine Windows Service (Data Collector)
  • SQL2K8 msdb
  • Etc (missed it)
 Data Collector Internals and Architecture
  • Data Provider (Collection Item)
    • TSQL
    • Performance Counters (e.g. sys.dm_os_performance_counters)
    • Trace Definition
  • Collection Set
    • Msdb Database tables
    • Linked to Agent jobs
  • SSIS
  • Management Data Warehouse
 Planning Tips and Tricks
  • Think Central
    • Collecting to a central MDW keeps you from monitoring the collection itself
    • Using a “Central Management Server” makes…
  • Watch the Clock
  • Space, the Final Frontier
 Performance Monitoring Tools Roadmap
  • Data Collection
    • Data Collection Sets
  • Performance and Diagnostics Monitoring
    • System Collection Sets Reports
  • Historical and baseline comparisons
    • Management Data Warehouse going forward
  • Trouble-shooting and Tuning
    • Policy based management

Other related posts:
GeekPost Weekly Newsletter Volume 4 Issue 7
MSDN Unplugged Roadshow Wellington
Right Sizing Agile Development - MSDN Magazine Webinar

Add a comment

Please note: comments that are inappropriate or promotional in nature will be deleted. E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.

Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and shown in this blog post.

Your name:

Your e-mail:

Your webpage:

JamesHip's profile

James Hippolite
New Zealand

Welcome to my technical blog. 

Here, I attempt to distill the Microsoft Certified Professional Developer knowledge I have accumulated since first qualifying MCP in 1996.  This blog started on 13 September 2007 as an off-shoot from my mixed up personal blog.  But it took a shot in the arm from Scott Hanselman's talk at TechEd New Zealand 08 "32 Ways To Make Your Blog Suck Less".