Home Dashboard Directory Help

DataCollector for SQL Server 2008 - View Reports Issue by Aravinda Damarla


 as By Design Help for as By Design

Sign in
to vote
Type: Bug
ID: 648960
Opened: 3/2/2011 3:19:04 PM
Access Restriction: Public
User(s) can reproduce this bug


Question is Regarding Data Collector ( Mangament Data Warehouse).
Though MDW Collects Data from Multiple Instances , there is no Option in GUI to View Report of Mutiple Servers from the Same Instance where MDW Exists .

We have to login to each Server to view the Data of each Instance . Rather it would be good if the Server where MDW Resides should have the Capability of View all the Data in the MDW of All Instances.
Sign in to post a comment.
Posted by Microsoft on 9/4/2012 at 3:57 PM
Hello we will consider this issue closed and answered.

Thank you
Alex Grach [MSFT]
Posted by Microsoft on 9/4/2012 at 11:33 AM

You can follow the steps listed in our team blog article http://blogs.msdn.com/b/sqlagent/archive/2012/09/04/data-collector-overview-report-for-multiple-instances.aspx

You can view this report by following these steps
1) Open SQL Server management Studio, Connect to SQL Server instance that is hosting Management data warehouse database (MDW)

2) Right click on MDW database, Select Menu
Reports -> Management DataWarehouse -> Management Datawarehouse overview

3) On right pane you will see a report that list all the instances that upload collected data to this MDW.
for each instance, you can launch the hyperlinks for reports that lets you view data collected by system collection sets

Sethu Srinivasan [MSFT]
SQL Server
Posted by Microsoft on 3/8/2011 at 12:16 PM
Thank you for reporting this issue - we are investigating and we will get back to you shortly.


Alex Grach
Sign in to post a workaround.