Access "Data collection the automated way in SQL Server 2008"
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 >>>
Premium Content for Free.
Catching up with Master Data Management products
by Don Jones, Contributor
SQL Server 2008 R2 hosts the Master Data Services feature, which can help businesses standardize sets of data. Microsoft didn’t quite let MDS gestate long enough, though, and it lacks a few crucial qualities.
Data collection the automated way in SQL Server 2008
by Roman Rehak, Contributor
SQL Server 2008's data collector feature automates the collection of critical performance data, which DBAs can then analyze using brand new SSMS reports.
- Catching up with Master Data Management products by Don Jones, Contributor
What every company should do with Business Intelligence
by Denny Cherry, Contributor
When used properly, the robust business intelligence stack in SQL Server 2008 R2 helps companies run more efficiently. Are you getting the most out of your BI?
- What every company should do with Business Intelligence by Denny Cherry, Contributor
More Premium Content Accessible For Free
These days, virtual servers are often seen as time- and money-saving efforts for businesses. When deciding if going virtual is the right thing to do,...
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business ...
Microsoft has worked to address the big issue of "big data," as companies are dealing with a constant influx of digital information. SQL Server is no...