Being proactive with Central Management Server

As promised in previous blog posts I am cranking out some videos to prepare for SQL Rally.  If you aren’t registered for SQL Rally register now. The price jumps up after April 30th. Alright everyone its time to get Proactive.

The goal for this video is very simple. I just want to show you how easy it is to execute a query against your SQL Server farm.  In this example I get proactive by finding database files that are low on space. Once, I find them I can extend them so we aren’t fragmenting our drives by depending on the autogrowth settings.

Central Management Server is a very simple but powerful tool.  To get a taste check out my video below.

[UPDATE 9/14/2011]

The query used in the video above can be found here.  If you liked this video checkout my tip on automating data collection with PowerShell and Central Management Server

2 responses to “Being proactive with Central Management Server

  1. Pingback: What “tool” to use for monitoring instances and where to store this data? | XL-UAT

Leave a Reply

Your email address will not be published.

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.

This site uses Akismet to reduce spam. Learn how your comment data is processed.