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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy