Page History
...
Diligent DBAs often employ mass defragmentation on their SQL Servers through self-made scripts or maintenance plans. Unfortunately, this approach falls short because no two tables or indexes have identical tuning requirements. Using this mass approach can also be problematic , because it often acquires unnecessary table and index locks during defragmentation, which can cause deadlocks.
...
Comprehensive reporting of analysis and defragmentation activity provides both DBAs and managers with the information they need to ensure database performance is continuously optimized.
Scroll pdf ignore | |||||
---|---|---|---|---|---|
Newtabfooter |
|
Need more help? Search the Idera Customer Support Portal
...