March 30, 2014 at 8:25 am
hello,
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/sec
after 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%
March 30, 2014 at 9:02 am
i turned off Query statistics collect and the MB/s to tempdb was rapidly decreased
March 30, 2014 at 9:08 am
If I understand this is because it use almost same queries like Activity monitor every 10sec, and inside these queries are #table , yes?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply