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

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 648960 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 3/2/2011 3:19:04 PM
Access Restriction Public

Description

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
Aravinda,

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


Thanks
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.

Thanks,

Alex Grach