Link to home
Start Free TrialLog in
Avatar of ShogunWade
ShogunWade

asked on

SAN Disk Fragmentation & SQL Server

Chaps,

MS SQL 2000 Index Defragementation Best Practices article, states that  "On scale environments that benefit from more intelligent disk subsystems, such as SAN environments, corercting disk fragmentation is not necessary"

Is this actually the case or will a heavily fragmented SAN have a performance impact on SQL.

Cheers

ASKER CERTIFIED SOLUTION
Avatar of mcmonap
mcmonap
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ShogunWade
ShogunWade

ASKER

Thanks for the feedback mc,   this sounds very plausable.   Im keen to leave the question open for a short period if you dont mind just incase someone has any info to the contrary, but what you say sounds fairly robust.


Cheers.
...however - rereading your question (I was really only thinking in terms of physical disk) and looking over the article ( http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx )?  I think the statement above only relates to physical disk defragmentation, the following suggests that SQL index defragmentation is still a worthwhile activity, I guess that the bigger the SAN the quicker it would occur as well.

"Obviously, having a high-performance I/O subsystem benefits SQL Server performance; however, performance gains can still be realized by defragmenting indexes across all systems."
Cheers once again MC.