It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

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.

Your browser does not support HTML5 and the Video tag. Please use the download links above.

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years and have all been given the MVP award by Microsoft