Thoughts and experiences of a DBA
There may come a time when you might want to shrink tempdb because it has become too large. There are a few ways you can do this and I have listed them below but please read to the end of the post before making a decision on which way you want to approach this. There [...]
SQL Server TempDB is a system database, automatically created when you install SQL Server. So what is it used for? Well a few things actually but first I have to tell you that Microsoft didn’t name tempdb because they couldn’t think of a suitable name. It is a temporary database which is re-created every time [...]
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. Some guidance points Place tempdb on a separate disk to user databases. See my post [...]
How to move tempdb ? You have to know that it is a system database so there are certain things you cannot do. Move tempdb – don’ts Don’t try and move tempdb using a backup and restore method as you will receive an error Msg 3147, Level 16, State 3, Line 1 Backup and restore [...]
Recent Comments