Sample Header Ad - 728x90

Does splitting 1 tempdb file into 4 require a SQL Server restart?

0 votes
0 answers
57 views
please can anyone help? I have a SQL 2008R2 instance with 4 cores, configured with 1 tempdb data file and 1 logfile. I want to change this setup as per best practices by adding 3 additional euqally sized files. I want to size the files to fill the capacity of the drive. The dedicated drive has a capacity of 50GB but a recent ad hoc user query pushed the size up to 47GB (log is 2GB). Are the following order of steps correct? Will it require a restart of SQLServer? Will the files be used proportinally by SQL Server correctly after, i.e. not pushing contention to a new file? 1) Shrink the original data file down to 12GB using DBCC SHRINKFILE. * Size taken up by the drive should now be 14GB (2GB log + 12GB data file 1) 2) Add 3 new additional data files at 12GB each. * The drive should now be full at 50GB capacity This will be done during a planned outage on a production system, but wanted to know if there will be any potential issues with the approach? Thanks in advance.
Asked by user2032414 (39 rep)
Jul 19, 2018, 08:13 PM
Last activity: Jul 19, 2018, 08:40 PM