SQLServerCentral.com / SQL Server 2012 / SQL 2012 - General / Data Collection ( MDW ) - tempdb / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 16:02:33 GMT20RE: Data Collection ( MDW ) - tempdbhttp://www.sqlservercentral.com/Forums/Topic1556278-2799-1.aspxIf I understand this is because it use almost same queries like Activity monitor every 10sec, and inside these queries are #table , yes?Sun, 30 Mar 2014 09:08:09 GMTtony28RE: Data Collection ( MDW ) - tempdbhttp://www.sqlservercentral.com/Forums/Topic1556278-2799-1.aspxi turned off Query statistics collect and the MB/s to tempdb was rapidly decreasedSun, 30 Mar 2014 09:02:29 GMTtony28Data Collection ( MDW ) - tempdbhttp://www.sqlservercentral.com/Forums/Topic1556278-2799-1.aspxhello,do you have experience with this? It is possible that Data Collection can cause massive increasing MB/sec to tempdb ? I cannot find connection with tempdb and I set cash file, but on same disk. Or it can be something different? Last two weeks what I checked was Read/Write MB/s to tempdb increasing progressively.One time it was about 20MB/secafter it was reseting and again 1MB/sec..Does you have experience with this? What I checked , External company which install SQL Server made one file for tempdb, next week or during breaktime(it will be possible), I would like make 8files next weekend work.Now I saw that TempDB mdf was still increased, but using was just 8-10%Sun, 30 Mar 2014 08:25:39 GMTtony28