HI,

Configured MDW data collector using wizard. All went fine and configured successfully without any error.

"System Activity" Collection is not working and not showing any report though upload job is running smoothly since couple of days. Other collections Disk Usage and Query Statistics working fine and reports showing data correctly.

So i have opened properties for "System Activity" and there are NO collection items which should be there in default configuration. However if i query "syscollector_collection_items" I can see relevant definition of this collection set. Please see attached screen where i have tried to show and explain the problem.

 

I ran following query to check the collection items defintion and all seems fine and results you can see in the above image as well.

USE msdb
SELECT 
 scs.collection_set_id
,scs.name
,scs.description
,scs.collection_mode
,scs.proxy_id
,scs.logging_level
,scs.days_until_expiration
,sci.name
,sci.parameters
,sci.frequency
,sci.collector_type_uid
,scs.collection_set_uid
--,*
from syscollector_collection_sets scs
INNER JOIN syscollector_collection_items sci ON scs.collection_set_id = sci.collection_set_id
WHERE 1=1
AND scs.is_system = 1
AND scs.is_running = 1
GO

So Questions are

1: Default collection item definition is there BUT its not visible in System Activity Properties?

2: System Activities upload jobs working fine But only System Activity reports are NOT showing any data. Why?

Share your thoughts please.

Should you need further information, please let me know. 

Thanks.

This is for Following SQL Server

Microsoft SQL Server 2012 - 11.0.5343.0 (X64) 
May  4 2015 19:11:32 
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Bui

Is there any error in the jobs history?

All Collection and Upload jobs are working fine.

No errors reported in any Log History for any Collection Set e.g. Server Activity Log History.

Surprisingly there is NO report or history graphs for first 12 months though collection and upload job is running every 15 minutes for server activity and as per default configuration by wizard.

1: After first 12 hours, Now reports and graphs are showing for last 12 hours out of total 24 hours collection. Why?

2: Still why default collection items are not visible in Server Activity properties? as that was my initial question though it is visible in system views.

Thanks and Regards.