I configured MDW on an SQL Server instance but when I try to access the reports from the MDW DB, the reports show information until a couple of days ago and I am getting 'collection set is not running. The data displayed here is from a previous run' as per below:

enter image description here

Why does this happen?


You have to enable Data Collection

Using SQL Server Management Studio

  1. In Object Explorer, expand the Management node.
  2. Right-click Data Collection, and then click Enable Data Collection.

or Using Transact-SQL

USE msdb;  
EXEC dbo.sp_syscollector_enable_collector;

FYI, MDW works using SQL Agent jobs, so the Agent has to be started and collector's jobs have to be enabled.

  • I have already done this Mar 11 '19 at 11:31
  • Have you started the Collection Set? Mar 11 '19 at 12:19
  • yes, data is being collected but I am getting that error in red for disk usage collection. Also Server Activity data collection is failing but query statistics is working perfectly Mar 11 '19 at 15:50

Not the answer you're looking for? Browse other questions tagged or ask your own question.