SQL Server Performance Forum – Threads Archive

Severe Fragmentation

I’m running SQL 6.5 on an NT box that is severly fragmented, my datafile is almost 11 GB and the drive stores over 200 GB of picture files (this is a driver license system). Will this hamper performance and possibly cause the db to be corrupt? ———-
T Kelley
MS, MCDBA, OCA, CIW

Its always advisable to keep the disks defragmented. Here %age free space also comes into picture. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Did you see any information or messages on event viewer and SQL error log, and any issues on performance? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Just doing some research mainly… Will a severly fragmented drive corrupt a database? ———-
T Kelley
MS, MCDBA, OCA, CIW

It won’t corrupt the data unless your harddrive gives out because it’s being worked to death. Also, there will be a significant improvement in speed once you’ve defragmented. HTH,
Larry

True, as Gaurav and Lalong referred its better to keep them defrag’d. You may not know disaster is waiting at next door…. (prevention is better than cure) <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /> _________ Satya SKJ Moderator SQL-Server-Performance.Com

Please, please upgrade from 6.5, you life will be much easier and performance will increase. SQL Server 6.5 has a bad tendency to get corrupt, as you probably know. Although fragementation by itself won’t cause it, it will probably eventually become corrupt just to irritate you. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

]]>