Premium Content

Access "Data collection the automated way in SQL Server 2008"

Published: 13 Oct 2012
Master data services: A work in progress

This article is part of the November 2010, Vol. 4 issue of Master data services: A work in progress

The data collector is a new feature in SQL Server 2008 designed to collect performance-related data from multiple servers, store it in a central data warehouse and present the data through reports in SQL Server Management Studio (SSMS). The main purpose of the data collector is to provide an easy way to automate the collection of critical performance data such as performance counters, snapshots of data grabbed from dynamic management views (DMVs), and disk space details. Since the feature collects information from the latest DMVs, it only works on SQL Server 2008. Still, it's worth noting that unlike many other useful DBA features, the data collector is not limited to the Enterprise edition only. The data collector feature in SQL Server 2008 consists of several components: The msdb system database is used to store so-called data collection sets containing the data collection definitions and jobs for collecting data with their associated schedules. Along with collection auditing and historical details, the msdb database also stores SQL Server Integration ... Access >>>

Access TechTarget
Premium Content for Free.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Already a member? Login to access this content.

What's Inside

Features

More Premium Content Accessible For Free

Back to top