How to defrag a sas drive

Asked By Mikey Lipman 20 points N/A Posted on - 10/22/2012

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

• Status: Open
• Question Views: 1317
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Security

Answered By Linknya Jean 0 points N/A #136613

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.

About Linknya Jean

Questions
2

Answers
107

Best Answers
25

• Vote Up 0 Vote Down

• Posted on - 10/23/2012
• Question Category: Misc Security