Maintain Microsoft SQL Server System and Performance Data with Windows PowerShell

Sign in to queue

Description

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often helps us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and helps us to track it down and fix the problem. This session walks 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.

For more information, check out this course on Microsoft Virtual Academy:

Day:

2

Session Type:

Breakout

Code:

DBI-B203

Room:

Room 391

Embed

Download

Download this episode

For more information, check out this course on Microsoft Virtual Academy:

The Discussion

Add Your 2 Cents