Continuing on from my post describing what SQL Server TempDB is used for, I wanted to write about tempdb best practices and how on a busy system, modifications to the default setup of tempdb and its placement can boost performance. How to optimize tempdb Place tempdb on a separate disk to user databases. See my post on how to move tempdb. Place tempdb on the fastest … [Read more...] about TempDB best practices
How to move tempdb
How to move tempdb ? So in this post, I show you what is involved to do this and what you shouldn't try and do. This is how to move tempdb You will need to run run some T-SQL and restart the sql server service to complete the operation. The logical file name values will need to be obtained and there are a couple of ways to do that. You can either view the logical file … [Read more...] about How to move tempdb