Post reply

Performance question

  • May 19, 2015 at 2:38 pm

    #304117

    Calling upon all dba experts 🙂

    Available storage: three LUNS at RAID10 with 1TB space for each LUN.

    From performance perspectives, will it be better to create three datafiles or six datafiles on those three LUNS?

    I read somewhere that while the performance won't be doubled if there are double the number of datafiles but there would be a definite increase in performance due to the number of SQL threads doubling.

    your feedback is appreciated.

    Thanks.

  • May 27, 2015 at 7:16 am

    #1800878

    Here is the post describing multiple data files.

    http://www.sqlservercentral.com/Forums/Topic1071180-146-1.aspx

    Alex S

  • May 27, 2015 at 7:19 am

    #1800880

    SQLJay (5/19/2015)

    but there would be a definite increase in performance due to the number of SQL threads doubling.

    False.

    SQL is not, in any way, limited to one thread per file. Any thread running within SQL Server can perform IO operations on any file

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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