Setting up TempDB

Question

Setting up TempDB

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

ab5sr SSCarpal Tunnel Points: 4056 More actions · Answer 1

Sweet!

Now go into perfmon and open up the SQL Server: Databases performance object. Throw in Transactions/sec for tempdb, and then _total (for all databases of course), and divide up to see how many are represented by tempdb. It can be surprising...

Iain-377297 SSC-Addicted Points: 429 More actions · Answer 2

I see a lot of variety in the answers given.....

1st before doing anything with the tempdb, You should also ensure that the Windows partitions are aligned: http://support.microsoft.com/kb/929491.

Aligning the disks will make a big performance difference.

2nd read these:

http://technet.microsoft.com/en-gb/library/cc966545.aspx

http://msdn.microsoft.com/en-us/library/ms345368(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms175527(SQL.90).aspx

Personally I would:

a) configure 1 data file per core, up to 16 cores is the current recommendation that I've heard from MS. So in your case 8 data files.

b) set each file to = (disk size - 25%) / 8, and turn off autogrow.