Analyze and Fix SQL Indexes
dbForge Index Manager is a handy SSMS add-in for analyzing the status of SQL indexes and fixing issues with index fragmentation.
The tool allows you to quickly collect index fragmentation statistics and detect databases that require maintenance. You can instantly rebuild and reorganize SQL indexes in visual mode or generate SQL script for the future use. dbForge Index Manager for SQL Server will significantly boost SQL Server performance without much effort!
Multiple Databases Scan
The tool allows to get an overall picture of a database as well as its specific objects for better fine-tuning. Flexible choice of connections and databases allows to easily switch between analyzed objects. Among other advantages are a combo box with user connections and auto-refresh upon switching between databases.
After scanning, Index Manager will prompt what actions must be taken against indexes - Rebuild or Reorganize. Sorting and searching simplifies the selection of necessary indexes. The tool also shows:
Reason for fragmentation
Export of Scan Results
The scan results can be saved to output file in the CSV format for further index fragmentation analysis or for the sake of reporting. You can generate reports on the state of indexes in your database using the CSV export.
|Component Environments||SQL Server NET Framework|
dbForge Index Manager
- Brand: Devart
- Product Code: v1.2
- Availability: In Stock
Tags: dbForge Index Manager