Index fragmentation may impact database performance
Friday, May 18, 2012
SQL Server Pro's Denny Cherry recently highlighted a EMC whitepaper and discussed how some vendors do not fully understand databases, which can impact companies' overall database performance.
The writer reported that the EMC whitepaper provided an overview of how database indexes can become fragmented. The research also said that defragmentation is needed to ensure proper SQL Server performance.
The real problem with the whitepaper is its instance that companies use index keys that are less likely to experience fragmentation, which the reporter asserted is not always an answer to such issues.
"Typically the clustered indexes will be built on a sequential ID number so there's no worry about that becoming all that fragmented, but all the other indexes - which can easily be bigger than the database - sorry, those won't be sorted by that ID number, pretty much ever - yes there are exceptions," Cherry wrote.
There are a number of IT developments that can significantly impact database performance. According to a Database Journal report, businesses are encouraged to have application developers understand how databases are designed and tested to ensure they are not overwhelmed by cloud computing or big data.