Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSD Performance & index fragmentation Expand / Collapse
Author
Message
Posted Friday, February 15, 2013 1:12 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 5:48 AM
Points: 484, Visits: 832
I'm not quite sure where is the best place to post this question but here goes.

My understanding is that if I were to install Windows onto an SSD drive then I would no longer want to defrag the hard disk - I was wondering if I were to start using flash storage arrays of one sort or another (I don't have a variety in mind, just a question out of interest) would index fragmentation still be an issue and need dealing with - presumably it would become an issue eventually but the rewriting activity would need to be minimised?

Does anyone know of any studies into this sort of thing with SQL Server & SSDs?

Thanks
Post #1420730
Posted Friday, February 15, 2013 2:49 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:47 AM
Points: 7,126, Visits: 12,727
Brent Ozar and Paul Randal both have posted research and findings on the topic. Google or Bing are your friend there. I just pulled back a bunch of relevant results.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1420780
Posted Friday, February 15, 2013 2:50 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 8:19 AM
Points: 40,208, Visits: 36,617
Fragmentation, probably not. Low page density (a side effect of fragmentation), hell yes. Having half of your expensive SSD going to waste because of low page density isn't the greatest of ideas.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1420783
Posted Friday, February 15, 2013 3:26 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 5:48 AM
Points: 484, Visits: 832
Thanks
Post #1420806
Posted Friday, February 15, 2013 3:27 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 2:18 PM
Points: 4,406, Visits: 6,268
GilaMonster (2/15/2013)
Fragmentation, probably not. Low page density (a side effect of fragmentation), hell yes. Having half of your expensive SSD going to waste because of low page density isn't the greatest of ideas.


I agree. I think Jonathan Kehayias did a blog post about that (and also about sequential IO actually being faster on SSDs too, just like on rotating media).


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1420807
Posted Monday, February 25, 2013 2:23 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 11:56 AM
Points: 880, Visits: 2,435
Yes, SSD's (and SSD's in RAID configurations) are indeed still faster for sequential access than they are for random access (significantly, in the case of writes, slightly in the case of reads). Spinning disks are significantly faster in sequential access for both writes and reads.

Note that I've provided some SSD performance results in the
RAID and Its impact on your SQL performance
thread.

Testing techniques and how to load the output into SQL Server comes from the FusionIO thread.
Post #1423776
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse