HiveBrain v1.2.0
Get Started
← Back to all entries
patternModerate

Index fragmentation and SSD disks

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
fragmentationssdandindexdisks

Problem

I'm new to performance problems, but I saw some discussion that SSD disks solve performance problems caused by index fragmentation.
Has anyone experienced this?
I'm thinking of changing my hardware and I'm wandering if that would help

Solution

Using solid-state drives certainly does reduce the performance impact of fragmentation, primarily because random I/O is so much faster than traditional storage.

Nevertheless, the reduction in page density (and extra logging) caused by page splitting is still undesirable and may still impact performance.

Generally speaking, well-maintained indexes with an appropriate FILLFACTOR are good regardless of physical storage considerations.

See Paul Randal's excellent article on TechNet for details.

Context

StackExchange Database Administrators Q#30811, answer score: 16

Revisions (0)

No revisions yet.