About this software
SQL Index Manager automates monitoring and maintenance of SQL Server indexes to improve query performance and reduce downtime. It analyzes fragmentation, recommends and executes rebuilds or reorganizations based on configurable policies, schedules maintenance windows, and records maintenance history and metrics for review.
Intended for database administrators and operations teams, it manages index maintenance across multiple instances and provides reporting to support decision making.
Purchase
Redgate SQL Index Manager
In Stock
Delivery: 1 working day
Loading...
€278.66
Free and without obligation
Do you need more information or looking for another license?
Benefits
- Automated maintenance: Schedules and runs index rebuilds or reorganizations based on configurable policies.
- Fragmentation analysis: Identifies fragmented indexes and recommends appropriate maintenance actions.
- Low-impact operations: Supports low-impact maintenance to minimize production workload disruptions.
- Multi-instance management: Manages index maintenance across multiple SQL Server instances from one console.
- Reporting and history: Tracks maintenance history and exposes metrics for auditing and tuning decisions.
Available languages
- English
Support information
- Documentation available: Product documentation and user guides are available on the publisher's website.
- Technical support: Technical support options are listed on the publisher's support portal.
- Knowledge base: Searchable knowledge base articles cover common configuration and troubleshooting topics.
- Product updates: Updates and release notes are published on the product documentation pages.
- Community forums: Community forums and user discussions are accessible through the publisher's website.
Frequently asked questions
What is Redgate SQL Index Manager?
A tool for managing and maintaining indexes in SQL Server databases, offering index analysis, maintenance scheduling, and reporting.
How does it identify which indexes need maintenance?
It analyzes index fragmentation and usage metrics to prioritize rebuild or reorganize operations, using configurable thresholds and maintenance policies.
Can index maintenance be scheduled to minimize production impact?
Scheduling, throttling, and phased execution options let maintenance run during low-traffic windows; online operations reduce locking where supported.
Does it provide reporting and auditing for index changes?
It captures maintenance history and performance metrics, producing reports and audit trails to review actions and verify improvements.
How does maintenance affect database performance and availability?
Index rebuilds and reorganizations consume CPU and I/O and may cause locks; choosing online operations, lower-priority scheduling, and incremental approaches reduces user impact.