The tempdb’s use as a temporary area space to create and delete temporary objects. The heavy usage of tempdb can lead to latch contention on the pages required to allocate or deallocate. In this blog, we’ll be covering what is tempdb contention and how quickly you can check the tempdb contention issue on your server. What […]