30th September - 2nd October 2010

University of York

Gold sponsors
Silver sponsors
Bronze sponsors

Building Real Time Performance Dashboards with Powershell

Need to build a fancy N.O.C. style dashboard ?

This session demonstrates how to use Powershell to build a fully featured real time performance dashboard for SQL Server.We will be going through the major resource groups to monitor, key thresholds to use and how to build your own performance dashboard in minutes.

Featured technologies are WMI performance counters, Powershell and Poshboard - the free web based IT portal build with Silverlight, and Powershell and recently released on codeplex.

Speaker focus

Bob Duffy

bob-duffy.jpg

Bob Duffy is one of a select group of Microsoft Certified Architects for SQL Server (aka SQL Ranger) around the globe. He has worked with SQL Server since 1997, and been designing database solutions ob varuous platforms for over 18 years. Bob has involved in more than 250 projects. Recently Bob was awarded MVP in SQL Server for 2009.

Currently Bob is helping customers in Ireland with enterprise SQL Design, Consolidation, Performance Tuning and Business Intelligence at the Prodata SQL Centre of Excellence in Dublin. Previously Bob spent three years with Microsoft Consulting Services specialising in SQL Server and Business Intelligence platforms.

Bob has spoken at many events including Technet and MSDN, The Irish Java Technology Conference, The SQL 2008 Technical Launch (Dublin, Belfast, Cork, Galway), the SQL Ireland Users Group, MTUG (Microsoft Technology Users Group), the Irish SQL Academy programme and Epicenter. Bob is also on the working group for the new SQL 2008 Masters exams


Bob Duffy's blog http://blogs.msdn.com/boduff/default.aspx



Downloads

No items to download

Other sessions from this conference

Denormalisation –having your cake and eating it.
Design patterns for SSIS Performance
Designing and Tuning high speed data loading
Event Driven Cube Performance and Security Monitoring
Fast Track Foundations: Get Serious about Sequential I/O
Getting Started with SQL Azure
High Availability in the Real World!
High performance functions
Improving Database Performance by Removing the Database
Inside the SQL Server Query Optimizer
Introduction to Performance Tuning Analysis Services 2008
Lessons Learned from 128 Core OLTP Testing
Make your DBA life better using SQL Server technologies - notes from field & best practices
Monitoring and Tuning Parallel Query Execution
Non-Functional Dependencies - A talktorial on getting performance and scalability right through proper Database Design and understanding Set and Relational theory
Optimizing tempdb and temporary object use
Performance Management for SQL Server with SCOM 2007
Performance Monitoring & Tuning - Documented Tips & Tricks
Performance Troubleshooting made easy with PAL
Photograph: SQL Server Crash Dump Analysis
Scaleout scenarios with Service Broker
SQL Server 2008 Reporting Services Scalability and Performance
Supercharge MDX performance using MDX Studio
Transaction Log Performance Tuning, Stop shouting Timber!