Maintain Microsoft SQL Server System and Performance Data with Windows PowerShell
Maintain Microsoft SQL Server System and Performance Data with Windows PowerShell
Play Maintain Microsoft SQL Server System and Performance Data with Windows PowerShell
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.
Download
Right click or Alt+Enter to download this episode
- MP3 (74.6 MB)
- Low Quality MP4 (441.5 MB)
- Mid Quality WMV (179.8 MB)
- Mid Quality MP4 (677.4 MB)
- High Quality MP4
- High Quality WMV
The Discussion
-
BIAdmin Would this solution complement SCOM or would it be redundant?
-
JGrover How well does this integrate with UCP?
-
JohnLowther Anything that keeps things running smooth is great with me!
-
stevefromtx Allen, great session today, thanks. Was wondering if the SSRS reports and script(s) used to extract the perf data will be in your forthcoming blog post?
Conversation locked
This conversation has been locked by the site admins. No new comments can be made.
