N/APosted on - 10/22/2012
I want to know that, how to defrag a SAS (serial attached SCSI) drive. Is that possible to Defrag the SAS Drives on Production Servers where SQL Database files reside? Please suggest me the appropriate solution.
How to defrag a sas drive
Hello Milkey Lipman,
You can defrag the database files on the physical disk by detaching the database, if they are on dedicated disk, or you could shutdown SQL Server also. Defrag.exe will not defrag a opened/locked file. Depending on the activity of your database you probably will not see a significant increase in performance by just doing defrag on the physical disk.
Thanks for sharing your problem with us.