dedicated drives for data, log and tempdb files

  • How does having dedicated drives for data, log and tempdb files increase sql server performance although the underlying infrastructure is the same?

  • we can keep data, log and temp files to dedicated drives its help to we performance improved because if u keep all files in one drive its faced space issues particularly when we do rebuild index task at that time temp db wants double amount of memory of actual database size

    while installation we can keep separate drives and after installation we can set data file location in database setting option

    while installation add user step is come in that step have data directory tab is there we can set there

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

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