Update Out-of-Date SQL Server Statistics

SQL Update Statistics - Free Tool

  • Launch directly within SSMS for optimal usability
  • Identify out-of-date SQL Server table and index statistics
  • View and change database statistics options
  • Create graphical histograms for each column’s statistics
  • Easy point-and-click rebuilding of statistics
  • Connect to cloud and run in cloud (provisional)

Identify Out-of-Date Statistics

Review the current state of the table and index statistics to determine if they need to be updated.

View and Modify Statistics Options

See the current automatic update statistics settings for the monitored database. Select database properties and table statistics to update, as well as, when to update statistics and sample size.

View Heartbeat Statistics

Build your own easy-to-read graphical view of each column’s statistics. Find out when statistics were last updated and changes since the last update.

Easily Rebuild Statistics

Use SQL Update Statistics’ point and click interface to initiate table and index statistics updates quickly and easily.

Integrate with SSMS

Designed to launch directly within SQL Server Management Studio (SQL 2012 and above) for optimal usability and efficient workflow.

Connect to Cloud and Run in Cloud (Provisional)

Connect to database instances hosted in the cloud, such as SQL Server on Azure Virtual Machine (VM), SQL Server on Amazon Elastic Compute Cloud (EC2), and SQL Server on Amazon Relational Database Service (RDS).

Run on virtual machines hosted in the cloud, such as Windows on Azure Virtual Machine (VM) and Windows on Amazon Elastic Compute Cloud (EC2).

IDERA Community

Check out the latest blog posts for product tips & tricks from other users.

Join the Discussion