Safely moving and creating new tempdb files

22 votes

3 answers

29868 views

sql-server sql-server-2008-r2 tempdb

                          Two things I'd like to know:

- how do you safely move tempdb with minimal downtime?
- how many tempdb files do you need?

Is it 1 file per core? So quad-core = 4 tempdb files, creating three new ones?

Asked by Stuart Blackler (4540 rep)

Jul 11, 2012, 06:49 PM
Last activity: Jun 18, 2024, 05:01 PM

Safely moving and creating new tempdb files

Related Questions