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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
...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."
"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."
ASKER
Cheers once again MC.
ASKER
Cheers.