Community

Troubleshooting Tempdb, a Case Study

(Michael J. Swart) At work, we store error messages from our web servers in a database. Up until recently, we were loading them using procedures that use wide TVPs. We discovered that if we saw a large enough spike in errors, then we’d also see tempdb contention which would flood our error logging s

Read More - Register for Free Membership