GilaMonster (10/9/2013)
60ms isn't bad. Not perfect, but way better than I've seen in many cases.If you're seeing IO bottleneck on TempDB, splitting the user DB into multiple files isn't going to do much.
Read operations are much faster... 2,7ms...
Each tempdb file, of the 4, has:
* io stalls read ms:
3.162.979
3.310.405
3.221.457
2.897.618
* # reads:
1.232.588
1.231.180
1.231.815
1.231.330
* io stalls writes ms:
77.075.513
76.980.693
76.948.258
76.979.508
* # writes:
1.332.084
1.331.643
1.331.944
1.330.562
These stats have been taken from Set 25th at 6PM till Oct 8th at 10AM... 12 and 1/2 days with 2 weekends (4 days with low ERP usage). 12,5 day = 1.080.000.000 ms.... 30% of the time tempdb has been io stalling for writes! Is this right or since it's 4 different files is just 1/4 of 30% ?!
Thanks,
Pedro