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?
Question: When to Use sort_in_tempdb for Rebuilding Indexes?
How to Grow All Files in a File Group Equally? – TRACE FLAG 1117 – Interview Question of the Week #201
Question: How to Grow All Files in a File Group Equally?
Answer: If you are a regular reader of this blog, you would have read my earlier blog post writing about this subject over here: SQL Server 2016 – Introducing AutoGrow and Mixed_Page_Allocations Options – TraceFlags. However, let us try to get an answer to our question in this blog.