SQL Server Performance

Placement of Tempdb Data and Log Files

Discussion in 'General DBA Questions' started by ddupuis, Dec 8, 2009.

  1. ddupuis New Member

    I am in the midst of configuring our new database servers and I am curious about how to place tempdb's files. We have seperate arrays for data, logs, backup and tempdb. My question is should I put tempdb's log file with the logs or with tempdb data? According to SQL Server this is our read/write ratios:
    Data: 92% read / 8% write
    Log: 13% read / 87% write
    Tempdb data: 35% read / 65% write
    Tempdb log: 5% read / 95% write
    Based on that I thought perhaps we could put the tempdb log with the rest of the logs. Also, would you configure your array controller cache settings with regards to the ratio or read/write to match the ratios above?
  2. Luis Martin Moderator

    How many processors do you have?
  3. ddupuis New Member

  4. esl New Member

    Hi,
    important thing is that you create as many tempdb files as there are CPU
    regards ,
    Eric
  5. Luis Martin Moderator

    That is why I asked.
    I suggest to put log in the same place than data (tempdb), but 4 in one array and 4 in other.

Share This Page