July 1, 2003 at 11:47 pm
Does anybody have any experience of heavily fragmented disks severely affecting the performance of SQL Server? I have a client experiencing high CPU on their SQL 2000 cluster that uses (quite heavily) fulltext indexing.
The only symptoms they've communicated to me so far are the high CPU (been building over time and now at a totally unacceptable level) and "the disks are EXTREMELY fragmented".
I will be visiting the client tomorrow but in the meantime I'd appreciate any experience other contributors have had with physical disk fragmentation, and steps that they then took.
TIA.
Cheers,
- Mark
July 2, 2003 at 10:56 am
Haven't seen that so much with SQL. Have seen issues with IIS. However, if the mdf/ldf are fragmented, multiple growths, then it could be an issue. Be sure to check if there are many physical reads. If not, then the disk may not matter. Also check the fragmentation of the log files.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply