question

jhunu avatar image
jhunu asked

data files

how many data files should I create for tempdb database for better performance result
sql-server-2012
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What makes you think you have a performance issue on your TempDB?
0 Likes 0 ·
viikiseth avatar image
viikiseth answered
ideally the number of tempdb files should is same to total number of CPU . Tempdb file size should be same for all. dont keep auto grow to unrestricted.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
I would disagree with a blanket recommendation such as that that @viikiseth makes. See for some discussion. In reality, the answer is going to be "it depends" - in this case, on your IO infrastructure, your server load, the query load your server is handling. And you should only start looking at this if you are experiencing issues with the performance of your TempDB.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

On two or four core machines it is pretty automatic. It's when you get into enterprise class servers and workloads that you need to thoroughly analyze your requirements. So even the "it depends" depends somewhat :)
1 Like 1 ·
I am thick. I saw the other post before I read yours.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.