Post reply

Adding datafiles to Tempdb

  • January 27, 2017 at 8:46 am

    #334537

    Hi all,

    In SQL SERVER production environment we have 8 processors, we have one tempdb data file ..Is there any chance that by adding datafiles in TEMPDB, impacts the performance???

    Regards
    Narine M

  • January 27, 2017 at 8:53 am

    #1925371

    Without knowing anything about your environment, I'd say it would be more likely to have a positive effect than negative.  But don't go adding too many!  Have a read through this before you do anything, and also click on the links therein.

    John

  • January 27, 2017 at 11:26 am

    #1925412

    John Mitchell-245523 - Friday, January 27, 2017 8:53 AM

    Without knowing anything about your environment, I'd say it would be more likely to have a positive effect than negative.  But don't go adding too many!  Have a read through this before you do anything, and also click on the links therein.

    John

    We have 8 processors, how many tempdb datafiles can be added....

  • January 27, 2017 at 12:23 pm

    #1925415

    Narine M - Friday, January 27, 2017 11:26 AM

    John Mitchell-245523 - Friday, January 27, 2017 8:53 AM

    Without knowing anything about your environment, I'd say it would be more likely to have a positive effect than negative.  But don't go adding too many!  Have a read through this before you do anything, and also click on the links therein.

    John

    We have 8 processors, how many tempdb datafiles can be added....

    There are some suggestions on how to do this but there really is nothing definitive - Microsoft's documentations are conflicting. It's probably best if you read one of the other articles on the same site as the earlier link. It has a link to one of Microsoft's articles on this as well as some suggestions. 
    A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core

    Sue

Viewing 4 posts - 1 through 3 (of 3 total)

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