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
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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.
Using SSDs can help with performance. If you've tuned your queries, added more memory and still have an overwhelmed I/O subsystem it's time to think about SSDs. Just adding a solid-state disk to your system will not boost the performance, you have to play smart. Analyze the workload and which part of I/O subsystem is overloaded to determine which data and log files to put on SSDs
More from Paul Randal: Benchmarking: Introducing SSDs . Check out all his posts about benchmarking with tests and graphs comparing SATA vs SSD performance