In the email yesterday from the client who earlier hired me for performance tuning had a small question about how to shrink tempdb database.
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.
Question: When Was SQL Server Last Restarted?