• Thank you Robert, I'd read your article "DEMYSTIFY TEMPDB PERFORMANCE AND MANAGEABILITY", this is very clear and very useful.

    According to the article, it seems like you would use one LUN for the whole tempdb database (option a, in the description below), but let me ask you which is your recommendation regarding the following question:

    If you have 3 LUNs (SAN and RAID protected) for organize your databases phisical desing, which option would you choose between the following configurations?

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

    b. One LUN for database files. One LUN for log files including the tempdb log file. One LUN for tempdb data files.

    c. One LUN for database files including tempdb data files. One LUN for log files. One LUN for tempdb log file.

    Thank you for your help.