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 – user1930901 Mar 11 '19 at 11:31
  • Have you started the Collection Set? – Denis Rubashkin 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 – user1930901 Mar 11 '19 at 15:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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