Audience
Developers looking to analyze, manage, and fix database index fragmentation
About SQL Index Manager
SQL Index Manager lets you quickly and easily find out the status of your indexes and discover which databases need maintenance. You can do maintenance through the UI, or generate a T-SQL script to run in SQL Server Management Studio. Detect index fragmentation to get a full report on indexes across your databases, including the severity of fragmentation and the reasons for it. Fix fragmentation by choosing which indexes to fix based on fragmentation severity – SQL Index Manager will perform the operation for you. Reorganize or rebuild by setting which action to take, based on customizable rebuild and reorganization thresholds, and rebuild indexes online with SQL Server Enterprise Edition. Analyze over time by exporting the results of your analysis to track and report on fragmentation. Generate scripts by automatically generating T-SQL scripts to fix fragmentation. Start rebuilding or reorganizing selected indexes with a single click.
Other Popular Alternatives & Related Software
Paessler PRTG
Paessler PRTG is an all-inclusive monitoring software solution developed by Paessler. Equipped with an easy-to-use, intuitive interface with a cutting-edge monitoring engine, PRTG optimizes connections and workloads as well as reduces operational costs by avoiding outages while saving time and controlling service level agreements (SLAs). The solution is packed with specialized monitoring features that include flexible alerting, cluster failover solution, distributed monitoring, in-depth reporting, maps and dashboards, and more.
PRTG monitors your entire IT infrastructure. All important technologies are supported:
• SNMP: ready-to-use and custom options
• WMI and Windows Performance Counters
• SSH: for Linux/Unix and macOS systems
• Traffic analysis using flow protocols or packet sniffing
• HTTP requests
• REST APIs returning XML or JSON
• Ping, SQL, and many more
Learn more
SolarWinds Database Performance Analyzer
Quickly pinpoint performance issues with SolarWinds® Database Performance Analyzer (DPA) while providing expert advice with tuning advisors. Anomaly detection powered by machine learning allows DBAs to proactively optimize databases before small issues become big problems. Real-time analysis with 24/7 monitoring and automated alerts provides the time an error occurred instead of just knowing it was “sometime last week.” DPA helps ease the use of more than 20 cross-platform databases in hybrid, on-premises and cloud environments.
Learn more
IBM Instana
IBM Instana is the gold standard of incident prevention with automated full-stack visibility, 1-second granularity and 3 seconds to notify.
With today’s highly dynamic and complex cloud environments, the average cost of an hour of downtime can reach six figures and beyond. Traditional application performance monitoring (APM) tools simply aren’t fast enough to keep up or thorough enough to contextualize the issues identified. Also, they are typically limited to super users who must complete months of training to learn.
IBM Instana Observability goes beyond traditional APM solutions by democratizing observability so anyone across DevOps, SRE, platform engineering, ITOps and development can get the data they want with the context they need.
Instana Dynamic APM operates using the Instana agent architecture, which incorporates sensors—lightweight, automated programs tailored to monitor specific entities.
Learn more
Splunk AppDynamics
Splunk AppDynamics delivers full-stack observability for hybrid and on-prem environments, linking technical performance directly to business outcomes. It enables teams to detect anomalies, diagnose root causes, and prioritize issues based on their real business impact. With capabilities ranging from network performance correlation to SAP system optimization, the platform offers deep insights across applications, APIs, and infrastructure. Its runtime security features safeguard applications by detecting vulnerabilities, blocking attacks, and highlighting potential risks. AppDynamics also enhances digital experiences with web, mobile, and synthetic monitoring to understand user journeys. By unifying performance, security, and business analytics, Splunk AppDynamics helps enterprises reduce costs, prevent outages, and deliver seamless customer experiences.
Learn more
Pricing
Starting Price:
$242 per user
Free Trial:
Free Trial available.
Integrations
Company Information
Redgate Software
Founded: 1999
United Kingdom
www.red-gate.com/products/sql-index-manager/index
Videos and Screen Captures
You Might Also Like
Monitor your whole IT Infrastructure
Caters to tech staff, system Administrators, and companies of any size, from small and medium sized businesses to enterprises that need their IT network to be reliable and easy to monitor in real-time. Equipped with an easy-to-use, intuitive interface with a cutting-edge monitoring engine. PRTG optimizes connections and workloads as well as reducing operational costs by avoiding outages while saving time and controlling service level agreements (SLAs).
Product Details
Platforms Supported
Cloud
Training
Documentation
Videos
Support
Not Offered