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
Last activity: Jul 19, 2018, 08:40 PM