SQL SERVER – Reducing Page Contention on TempDB
- by pinaldave
I have recently received following email.
“We are using TraceFlag 1118 to reduce the tempDB contention on our servers (2000 and 2005). What is your opinion?
We have read lots of material, would you please answer me in single line.”
Wow, this was very interesting question. What intrigued me was the second last where I am asked to answer in a single…