SQL Server Home
DataCollector for SQL Server 2008 - View Reports Issue
as By Design
3/2/2011 3:19:04 PM
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.
SQL Server 2008 R2 - Enterprise Edition
Tools (SSMS, Agent, Profiler, Migration, etc.)
Windows Server 2008 R2
Operating System Language
Steps to Reproduce
Configure MDW for Multiple Instances and View the reports from 'Collection Set Reports' . It will display the Report of the Data only specific to the Instance you have logged in .
You need to login each of the Instance to view Reports .
It will display the Report of the Data only specific to the Instance you have logged in .You need to login each of the Instance to view Reports .
Reports should display option to chose Data from which Server should be Reported
to post a comment.
Please enter a comment.
on 9/4/2012 at 3:57 PM
Hello we will consider this issue closed and answered.
Alex Grach [MSFT]
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]
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.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft