patternModerate
Index fragmentation and SSD disks
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
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
See Paul Randal's excellent article on TechNet for details.
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.