Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Physical SQL file defrag - needed?
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00698307
Message ID:
00698598
Views:
15
>I would guess you would have to mirror the hard drive or server. Also, it was my understanding that NTFS didn't fragment, or that it didn't affect it's performance. Of course, this could be MS hype.
>
>BOb

Bob,
the server is on RAID5. According to that article, NTFS fragments as well. I am hesitant to try defragmenting, but I have recently switched to an identical server due to hardware issues and the performance on the new server is much, much worse. I am thinking fragmentation is the only thing that is different.
Aristotle
Previous
Reply
Map
View

Click here to load this message in the networking platform