Diagnosing and Fixing tempdb Contention from Spills in SQL Server
Thanks for watching!
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.
On recent non-VMs… use of NVMe for tempdb shiuld minimize this potential, right?
Well, this is a VM, but it’s a very local VM working on direct attached NVME. So you are free to draw conclusions from that.
Would you mind telling us why you use “Sort_In_tempdb = on” ?
“A friend of mine” always told tought that meant double the writes.
I use it to avoid unnecessary user database file activity. It’s difficult to figure out the intent of your second sentence, so I’ll leave it be.