Maintain Microsoft SQL Server System and Performance Data with Windows PowerShell

Download this episode

Download Video


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:



Session Type:





Room 391



Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.