About two weeks ago Microsoft have released a new version to their SQL Management Pack with the new version 220.127.116.11. As it turns out, there are some issues with the MP and Microsoft recommends you don’t install it.
UPDATE (10/22/2015): We have removed this release from Download Center for the time being. Large number of customers reported seeing an issue with tempdb and DW log growing above normal levels. We are working on a fix and will release an update as soon as we have it ready.
In case you already installed it, there’s a workaround to solve the issue:
If you have already installed 18.104.22.168 and seeing this issue in your environment, please run the script below to mitigate the problem. You should still update your environment when we have the new release available even if you run the workaround. We apologize for the trouble this has caused you.
alter procedure sdk.Microsoft_SQLServer_Visualization_Library_UpdateHierarchy as RETURN 0;
alter procedure sdk.Microsoft_SQLServer_Visualization_Library_UpdateLastValues as RETURN 0;
update sdk.Microsoft_SQLServer_Visualization_Library_Tables set LastProcessedId = 9223372036854775807;
Head over to the official blog for more info.