• Hernán Rojas (8/6/2012)


    Thank you GSquared for your answer. I would like to ask something else:

    If you only have 3 disk for organize your databases phisical desing, which option would you choose between the following configurations?

    a. One disk for database files. one disk for log files. one disk for tempdb (data and log files). or...

    b. One disk for database files. one disk for log files including the tempdb log file. One disk for tempdb datafiles.

    Thank you for your help.

    Hernan.

    No single right answer. What kinds of disks are these? SAN or Local? RAID level? SSD vs SATA vs SAS? How much of a load does your application put on tempdb?

    It's trivial to move tempdb data/log files and without actual performance metrics from your production environment, I'd go with option C ( Monitor performance until you have proof that you need to worry about where tempdb lives.)