The other day I ended up a very interesting situation while working with Comprehensive Database Performance Health Check, with TempDB files.
During the recent work of Comprehensive Database Performance Health Check, we had a very interesting situation of Dynamic SQL and Global Temporary Tables.
Their server got tremendously slow with many sessions suspending in the status of SUSPENDED status and they were waiting on PAGELATCH_UP and PAGELATCH_SH.
SQL Server Expert Ahliana Byrd has written a very interesting script to DROP Multiple Temp Tables Using Cursors on Azure, which we have included today.
We fixed quite a lots of things at customer place with regards to TempDB and he finally was able to get “the Flash” fast performance.