I checked the data in sysssislog and there are still a lot of Data Collections rows which the script from MDSN support does not address. Looks like we will...

The script provided by MSDN Community Support below targets the rows in sysssislog generated by Data Collections:

USE msdb;
DELETE FROM dbo.sysssislogWHERE source...

There are no packages deployed to the SSISDB database.

Thanks for the suggestion - I have logged this issue with MS Connect - please vote it up here: https://connect.microsoft.com/SQLServer/feedback/details/3116261

In the meantime we will do a manual cleanup...

The issue is not the MDW - it is that the rows in MSDB are not cleared up by any of the History Cleanup tasks.

There is no SSISDB catalog - and no SSIS activity other than the Data Collections. Its clear that the MDW is generating the millions of rows - the values for...

TDE is Enterprise only: https://msdn.microsoft.com/en-us/library/cc645993.aspx

Can I get my point for answering correctly?

Thanks for posting this - it is a great database monitoring solution. We have it in production on all versions of SQL up to SQL 2016. Note that in SQL...

Ok - found a Connect item for this - please vote it up: https://connect.microsoft.com/SQLServer/feedback/details/2887824/data-collector-does-not-collect-performance-counter

Thanks for the script - could also add "@notify_level_eventlog=2," to set the Write to Windows Application Event Log option.

We had the same issue - just restarted the Report Server service after deploying the charts to resolve.

Thanks!

We were getting the same issue loading a sharepoint list which had been running without problems "Error: System.TimeoutException: The request channel timed out while waiting for a reply". Changing the...

Hi,

The SCD method requires a "business key" to match the records in the source and destination - as long as they have this then you should be able to use...

Ok - got this - it was caused by leaving the TargetDataSourceFolder blank (had always done this in RS2005 to deploy datasources to same location as reports etc).