Home Dashboard Directory Help
Search

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


Status: 

Closed
 as By Design Help for as By Design


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

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.
Details
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
Sign in to post a workaround.