Post reply

TempDB File Structure

  • January 2, 2004 at 10:20 am

    #66240

    We have a 4 processor server running NT4 with SQL Server 7 SP4. TempDB is used quite a bit due to analystic staff creating many temp tables, slowing the system down. Will the addition of more files to the TempDB log file help?

  • January 2, 2004 at 10:33 am

    #488501

    It can help, each file uses a different thread, so this can be benficial. More physical drives can help as well.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

    http://www.dkranch.net

  • January 2, 2004 at 10:39 am

    #488505

    Only adding files to the tempdb log won't help you too much.

    Considere the followings:

    • The tempdb should reside on the fast disk drives on RAID1 or RAID10 and definitly not on RAID5
    • Be shure to size your tempdb big enough to avoid autom,atique filegrow
    • You should enough RAM within your box
    • Be shure to have trunc log on checkpoint set
    • If you have plenty of disks then it is a good idea to build the data, index, log, tempdb and system/master files on separate disks/filegroups

    Bye

    Gabor



    Bye
    Gabor

  • January 2, 2004 at 1:36 pm

    #488524

    I think SQL doesn't write in parallel to Log files. It just will use another file, when the first is full. So adding log files won't help.

    But it might help adding data files.

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

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