0

On sql server 2008 r2 how do I check that tempdb files are configured for one data file per physical processor core? I have been looking on SQL Server Studio screens, but I haven't been able to find where can I find that information. Is this one of those situations where you need to run a script to find out the configuration, or can I find the data on SQL Server Studio?

Kwang Mark Eleven
  • 165
  • 1
  • 1
  • 6

1 Answers1

2

To see the files configured for a particular database, right click on the database, select Properties and then the information you need should be in the Files tab on the properties screen.

I'm not sure the TempDB -> 1 file per physical core / cpu thing actually has any basis in reality however. There's probably a bunch of other things that make a bigger performance difference, such as the nature of the disks TempDB is hosted on and what they happen to be shared with.

growse
  • 8,020
  • 13
  • 74
  • 115
  • 1
    I believe the one TEMPDB file per cpu/core was a best practice recommendation for SQL 2005 and ealier but I don't know if it is for SQL 2008 and 2008R2. – joeqwerty May 07 '12 at 16:58