Sql Move Tempdb Log File' title='Sql Move Tempdb Log File' />SQL Server 2. Your tempdb is the size it needs to be. It will just grow again, just even more fragmented on disk and possibly blocking while it grows too. Patch Panel Prices In South Africa. More seriously, Id set the size of tempdb to soemthing sensible and slightly larger than now, shut down SQL, delete the old files to be 1. Codec S For Windows Movie Maker. SQL Server up again. Art-103.JPG' alt='Tempdb Multiple Files' title='Tempdb Multiple Files' />Best practice for tempdb log file. I have read many blogs here and there about how to configure tempdb data files but i didnt found any information regarding the tempdb log file. Heres the strategy that Im presently using with my tempdb I have used the recommendations of Paul Randal on how to split my tempdb data files. I have set the size of my tempdb data files to their maximum and disabled autogrowth. For example, i have 1. This prevent fragmentation on the disk as recommended by Brent Ozar and also I have 2. But like I said, nobody is talking about the tempdb log file. Distributing Tempdb files. SQL Server 2005, 2008. This LUN is dedicated to tempdb only and I create multiple data files and one log file on that. Working with tempdb in SQL Server 2005 Misconceptions around TF 1118 TempDB Monitoring and. Log in hand want to create multiple files for tempdb. Internal objects that are created by the SQL Server Database. SQL Server 2005. What should I do with it On my setup, this file is at the same place as the tempdb data files. What is the size and the autogrowth value that I should use with the tempdb log fileSql Server TempdbWhat is the best practice for configuring tempdb behind having multiple files is that each file. This is a very straight forward procedure in SQL 2005 1 Open SQL Server. Log files. phptitleCreateMultipleTempDBfilesforbest.