none
Add files to tempDB: what to watch for

    Question

  • I've read that adding multiple data (ndf) files to tempdb, all of the same size, should reduce contention in this much-used DB. How can I tell (e.g. performance counters, DMV) if, in fact, adding the extra files has improved things or not?

    TIA,

    edm2

    Friday, February 3, 2017 3:43 PM

Answers

All replies