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

Closed

as By Design Help for as By Design

Type:	Bug
ID:	648960
Opened:	3/2/2011 3:19:04 PM
Access Restriction:	Public

Workaround(s)

view

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.

Details (expand)

English

SQL Server 2008 R2 - Enterprise Edition

Tools (SSMS, Agent, Profiler, Migration, etc.)

Windows Server 2008 R2

English

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

X64

0 attachments

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

Microsoft