Category: Fragmentation

Lee Walsh covers index fragmentation, several ways you can identify it, and why a more granular approach to index maintenance can save time and allow you to focus on other tasks during maintenance windows.
May 18, 2021 | Lee Walsh | SQL Sentry, Fragmentation, Indexes 0
Do you know if the nonclustered indexes in your databases are being used effectively? You may think they are, but do you really know?
February 9, 2018 | Andy Yun | SQLBits, Fragmentation, SentryOne 5
Jonathan Kehayias explains why, among other reasons, the impact on execution plans can make index fragmentation something you should care about.
December 18, 2017 | SQLPerformance.com | Performance, Fragmentation 0
Mike Wood introduces SentryOne's Azure Marketplace.
Melissa Connors continues her series on data compression, focusing on costs of implementation, index maintenance, and running SQL Sentry.
Paul Randal of provides some thorough and helpful tips on reducing or eliminating index fragmentation.
Aaron Bertrand shows how to use the RunAs command to connect the SQL Sentry Client, Plan Explorer, or SSMS to a database in another domain.
Paul Randal of SQLskills describes several ways clustered index fragmentation can sneak up on...
March 18, 2015 | SQLPerformance.com | Fragmentation 0
Erin Stellato of SQLskills.com continues her series on proactive SQL Server health checks, this time focusing on mastering maintenance tasks.
Lori Edwards explains an add-in for SQL Sentry Performance Advisor, Fragmentation Manager, aimed at helping you manage and automate index maintenance.

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More