Monitoring, Maintaining, and Tuning, For Database Administrators, For IT Professionals

SQTH11 Maintain SQL Server System and Performance Data with PowerShell

12/13/2012

11:00AM - 12:15PM

Level: Intermediate

Allen White

Allen White

Practice Manager

UpSearch Technology Services

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data, and a set of reports to show you how to use that data to keep your server running smoothly.

You will learn:

  • How to set up and maintain an administrative database to manage servers
  • Performance metrics and how to build a baseline set of counters
  • How to use PowerShell to build and maintain your admin database and gather information to ease management of your servers