Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (2Microsoft Partne)
  • When: 12 Aug 2012 4:15 AM
  • Last revision by (eMicrosoft Partne)
  • When: 30 Jul 2013 7:15 AM
  • Revisions: 14
  • Comments: 1
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  Step By Step Guide for Configuring Data collection and Data Management Warehouse in SQL Server 2012

Step By Step Guide for Configuring Data collection and Data Management Warehouse in SQL Server 2012

Step By Step Guide for Configuring Data collection and Data Management Warehouse in SQL Server 2012

Table of Contents

 

Introduction

"The data collector is a component of SQL Server 2008 that collects different sets of data. Data collection either runs constantly or on a user-defined schedule. The data collector stores the collected data in a relational database known as the management data warehouse.

The data collector is a core component of the data collection platform for SQL Server 2008 and the tools that are provided by SQL Server. The data collector provides one central point for data collection across your database servers and applications. This collection point can obtain data from a variety of sources and is not limited to performance data, unlike SQL Trace"  MSDN

High Level Data Collection  Implementation Guide

At a high-level Data collection can be impleted by using this guide
1.  Configure a Management Datawarehouse
2. Configure Data Collection

Detailed Implementation Guideline for Configuring  Data collection

A.  Step by Step Guide for building Data Management Warehouse

Step 1. Configure DMW

Figure 1.  Configuring DMW in SQL Server 2012

Step 2. Management Datawarehouse Wizard


Step 3. Create DMW.


Step 4.



Step 5.


Step 6.


Step 7.


Step 8.


Step 9


B. Step by Step Guide for Configuring Data collection



Step 1.


Step 2


Step 3.


Step 4.


Step 5.
, , , , , , [Edit tags]
Leave a Comment
  • Please add 7 and 3 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
Page 1 of 1 (1 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
Page 1 of 1 (1 items)