Post reply

Temp DB Best Practices

  • July 14, 2009 at 3:58 pm

    #202251

    Hi,

    We are building a new server planning migration from sql 2005 to sql 2008 on windows 2008 server.

    we have an 16 processor,64 GB RAM,.Each Database has seperate SAN of 2tb

    We are planning to set up the TEMP DB on a seperate disk which is of 300GB and RAID 10 .

    As a best practice we are planning to stripe the Data file to 16 files i,e one .mdf and 15 ndf's.

    our largest database is around 1TB at present (Data coming in).With huge transaction processing and Batch processes going on.

    we are struck up with Defining the optimum sizes for the LOG and Data Files.

    Are there any particular statistics to set the Data and log file sizes.Like Log file should be 1/2 the size of Data file.

    Tried searching online lot of articles but cannot find any particular statistics.

    Any help is appreciated.

    Thanks in Advance!!!

  • July 14, 2009 at 4:21 pm

    #1024763

    Please don't cross post.

    Answers please here .


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • July 14, 2009 at 4:30 pm

    #1024771

    sry was very urgent so had to cross post...

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

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