Microsoft recommends separating the SQL Data Files from the Temp Files to limit device contention but what about cases involving shared storage. I have a shared environment where the data and temp files are located on the same mount point or LUN. Is it best practice to separate them onto different? Or will it make a difference from a performance standpoint?
Aucun commentaire:
Enregistrer un commentaire