How to defrag a sas drive

Asked By 20 points N/A Posted on -
qa-featured

Hi,

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.

Thanks.

Regards

SHARE
Answered By 0 points N/A #136613

How to defrag a sas drive

qa-featured

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.

Login/Register to Answer

Related Questions