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 – DROP Multiple Temp Tables Using Cursors on Azure
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.
SQL SERVER – 5 Performance Optimizations Must Do for TempDB
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.
When Was SQL Server Last Restarted? – Interview Question of the Week #225
Question: When Was SQL Server Last Restarted?
When to Use sort_in_tempdb for Rebuilding Indexes? – Interview Question of the Week #207
Question: When to Use sort_in_tempdb for Rebuilding Indexes?