Home Forums SQL Server 2014 Administration - SQL Server 2014 how to allocate the File sizes (Disk Partition Alignment for tempdb) RE: how to allocate the File sizes (Disk Partition Alignment for tempdb)

  • June 29, 2015 at 7:17 pm

    #1808957

    Database admin(DBA) (6/29/2015)

    I have question about tempdb needs to be configured 100GB 64kb block size.its fresh installation.

    how to allocatte the file sizes.still im not sure how many log files needs to be created with 100GB equals to 64KB block size.

    Can you explain me what is 64KB block size and how to divide the logfiles 64KB into the 100gb or 50GB?

    what is 64 KB cluster has 128 sectors?

    tempdb drives should be formatted with a 64K allocation? how many files needs to created for good performance with 50GB or 100GB? ot 1TB

    Please suggest me.

    Thanks in advance!!

    Thanks & Regards,

    DBA

    You've got 3 separate tags on your post that claim you're a DBA. You should know this off the top of your head (or at least how to Google for such a thing) or you should humble down a bit.

    Here's a start...

    https://www.google.com/?gws_rd=ssl#q=number+of+tempdb+files+kimberly++tripp

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)