Daily Archives: October 6

Fragmented index can slash your performance within WorkSite
Fragmented index can slash your performance within WorkSite

“Right now in your data center, a vicious, unforgiving villain is slowly draining the performance from your database servers. It strikes without warning and doesn’t leave a trace in event logs or messages. This killer is fragmentation.” (via SQL Server Fragmentation: The Basics | Brent Ozar PLF.) A badly-fragmented index can impose a performance penalty…

Read more