So I setup the Management Data Warehouse on a performance testing environment for our company. My first time using this report warehouse.
I got it all configured and the 5 jobs for collecting and uploading data are executing successfully.
The Disk Usage report is accurate in that it shows the databases and sizes, etc.
However the other two reports for Query Stats and Server Activity are completely blank. No errors. Just not data either.
The QA tests tell me there are hitting on this Performance Test environment and they expect data should be there. But there is nothing.
Any ideas on what I should be looking at now to get the SQL Server activity to show up in the MDW reports?
Thanks in advance.