[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1014
  • Last Modified:

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

0
ShogunWade
Asked:
ShogunWade
  • 2
  • 2
1 Solution
 
mcmonapCommented:
Hi ShogunWade,

I understood this to be correct since hotspot activity gets balanaced out in intelligent SANs.  As I understand it ('course I may be worng!) in big SAN's you don't really have a "disk" - you have virtual space where things are stored, depending on how the SAN feels it may move the data around in order to spread load away from busier disks and onto quieter ones.  Fragmentation becomes less of an issues because of the large number of disk spindles you have accessing your data in parallell.  I think that by defragmenting you a try a pile everything together which negates the point of spreading the load through the SAN.

So I think it is actually the case.
0
 
ShogunWadeAuthor Commented:
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.
0
 
mcmonapCommented:
...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."
0
 
ShogunWadeAuthor Commented:
Cheers once again MC.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now