Sql-server – Management Data Warehouse SQL Server data collection reports

data collectionsql server

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?

Best Answer

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;  
GO  
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.

Related Question