Thanks to the Wisconsin Virtual SQL Server User Group for letting me talk about tempdb today! The slides and demo queries are attached. Once the recording is available I will update this blog with a link to it. Taming the Tempdb Tempest Summary: · Multiple data files of the same size, one log file · Continue reading “Taming the Tempdb Tempest – WI SQL Server Virtual User Group, 22 Apr 2011”
Tag Archives: tempdb
Compilation of SQL Server TempDB IO Best Practices
It is important to optimize TempDB for good performance. In particular, I am focusing on how to allocate files. TempDB is a unique database in several ways. The ones most relevant to this discussion are: · It is often one of the busiest databases on an instance. This means the performance of TempDB isContinue reading “Compilation of SQL Server TempDB IO Best Practices”
