Gather SQL Server Performance Data with PowerShell

Understanding how your servers behave normally is critical to knowing where problems really are when they occur.  Reporting that in a form that's clear and consistent gives you credibility with your boss and your users.  In this session we'll discuss what performance counters to capture and why, and walk through a PowerShell script that gathers those counters and loads them into your administrative database where we'll then build a report showing the counter data in a way that easily shows you the performance characteristics of your system.  By tracking this over time you understand how the system is doing and will learn to easily see where the problems are when they occur.
Presented by Allen White at SQLBits IX
  • Downloads
  • SpeakerBIO
    Allen is a Practice Manager for Upsearch Technology Services in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT.  Allen has been awarded Microsoft’s MVP Award for the last Six years. He's President of the Ohio North SQL Server User's Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell, and maintains a blog at
  • Video