SQL Server Index Analysis & Defrag

Fragmentation Manager dramatically improves the manageability and visibility of index fragmentation across the SQL Server enterprise. It helps you to make good decisions about how and when to defragment, and then defrags indexes faster than ever before via support for multiple concurrent operations.

 

  • The integration with Performance Advisor allows you to assess the impact of fragmented indexes and tables on server and query performance.
  • Multiple historical charts showing used and wasted space, for both disk and buffer, at the table and index level.
  • Built-in defragmentation notifications so you can be as informed as you want, regarding the status of your defrag operations.

Product Datasheet

The Product Datasheet provides you with all of the features in our tools. You can easily compare our tools and see which ones fit your organization's needs.

 

Overhead Analysis

The SQL Sentry Overhead Analysis provides both qualitative and quantitative information about the overhead impact you should expect from SQL Sentry Event Manager and Performance Advisor.

 

Features

Automated Defrag

Fragmentation Manager Automatic Defrag

Quickly and easily set up automated defrag schedules across your environment via point-and-click and drag-and-drop. You can set specific schedules for different servers and databases, down to the individual table or index level as needed and use different schedules for very large indexes that need to be analyzed and defragged separately. You can also selectively defrag only the max partition or all others because Fragmentation Manager offers full support for partitioning sliding window scenarios.

Fragmentation Reports

Fragmentation Manager Fragmentation Reports

Fragmentation Reports display index-related statics, from the computer level down to the individual index level, which allows you to quickly identify trends and diagnose problems. They also display the state of fragmentation on a server and help you make good decisions about how and when to defrag your indexes, adjust fill factors, or even change index definitions. There are also multiple charts, which show used and wasted space, for both disk and buffer, at the table and index level.

Defrag Performance

Fragmentation Manager Defrag Performance

By allowing more than one concurrent defrag operation, Fragmentation Manager can dramatically speed up your defrag process, thereby reducing the maintenance window required for defrag. With the Performance Advisor dashboard and Disk Activity view, you can easily assess the performance impact of increasing concurrent defrag operations.

Benefits

Manageability

With SQL Sentry Fragmentation Manager, it is easy to set up an environment-wide schedule to automate defragmentation operations, while allowing the flexibility to customize the schedule and other settings for specific instances, databases, tables, and even individual indexes. You can analyze the impact of fragmentation on query and overall server performance thanks to the integration with Performance Advisor, and you can review and manage defrag schedules on the SQL Sentry calendar with Event Manager.

 

Speed

Fragmentation Manager allows you to control the number of concurrent defrag operations, and when more operations can happen in parallel, your maintenance window becomes smaller. You can very easily monitor the impact this has with Performance Advisor, and make adjustments as necessary.

 

Continual Innovation

While other SQL Server monitoring tools have stagnated, SQL Sentry has continued to push the envelope, introducing several industry firsts such as our patent-pending SQL Server disk analysis, unrestricted historical performance reporting, comprehensive deadlock analysis, performance event calendars, intelligent wait analysis, and many more cutting edge features.

 

Lower Overhead

SQL Sentry's tools are built to be minimally invasive and incur the lowest possible hit on monitored servers via our agent-less architecture... while other SQL Server monitoring tools incur far more load than they will ever help you to resolve. Some even filter out all of their own query activity so you never see it! Don't be fooled by misleading claims of lower overhead - install SQL Sentry alongside other tools to see exactly how much of a performance hit they incur. Download our Overhead Analysis.

 

Lower Cost

SQL Sentry software continually delivers more features, functionality and utility than other SQL Server software tools, at a lower price point. With subscription-based and site licensing options, the relative savings can grow even further.

 

Visibility

From the instance down to each index, Fragmentation Manager provides both graphical and tabular data representing index-related metrics, which make trends and events more obvious, getting you one step closer to solving space and performance issues.

 

Scalability

SQL Sentry software is installed in some of the largest SQL Server environments in the world. Our low overhead, agent-less, site-based approach provides almost linear scalability. We have yet to meet a SQL Server environment that the SQL Sentry architecture can't handle.

 

World-class Support

SQL Sentry provides the highest level of support services you will find in the SQL Server software world. Our clients continually rave about the responsiveness and technical competence of our support team. You will never speak to a non-technical front-line person that doesn't understand SQL Server or SQL Sentry software. To the contrary, you will often be speaking directly to a development team member.

 

Credibility

We've been a Microsoft Gold Certified Partner for many years, and our customer survey results say it better than we ever could. Our marks across the board are consistently higher than other Microsoft partners. All customers fell into the "Champion" quadrant, ranking us amongst the top Microsoft ISVs in the world. Survey results

 

Higher Quality

SQL Sentry software undergoes intensive regression, scalability and overhead testing in our internal test lab of over 100 SQL Servers. It is then real-world tested in one of the largest SQL Server hosting environments in the U.S., until it is deemed stable enough to release to the public... no matter how long it takes. After release, our integrated, automated exception reporter gives us a perpetual feedback loop with our customers, who are continually surprised to receive a response from a real human usually within hours of submitting an exception.

 

Videos

Fragmentation Manager Overview

Fragmentation Manager Overview

SQL Sentry Fragmentation Manager introduces new automated index maintenance capabilities to Performance Advisor. This video is a brief overview of the features within Fragmentation Manager.

SQL Sentry - New in Version 7

SQL Sentry Version 7 offers significant new features including integrated index analysis and defrag, mirroring monitoring and much more. We’ve also completely re-architected our alerting and notification functionality.

Pricing

SQL Sentry Fragmentation Manager is licensed per individual monitored Microsoft SQL Server instance, and also requires a SQL Sentry Performance Advisor license for each monitored instance. First year annual software maintenance is required and provides technical support via e-mail and phone, fixes and updates and free version upgrades.

For a complete listing, view the product price list and online store.

  License Maintenance
Fragmentation Manager
$795.00 $159.00
SAVE 50% / $2,375.00 Fragmentation Manager Quick Start 5-Pack
$2,395.00 included
SAVE 23% / $880.00 Power Suite PLUS
(1) Performance Advisor for SQL Server
(1) Event Manager for SQL Server
(1) Performance Advisor for Windows
(1) Event Manager for Windows
(1) Fragmentation Manager
$2,995.00 $599.00
SAVE 44% / $7,975.00 Power Suite PLUS Quick Start 5-Pack
(5) Performance Advisor for SQL Server
(5) Event Manager for SQL Server
(5) Performance Advisor for Windows
(5) Event Manager for Windows
(5) Fragmentation Manager
$9,995.00 included

Requires a SQL Sentry Performance Advisor license for each monitored instance.
Quick Start 5-Packs are only available to new customers with a limit of 1 per company. The first year annual software maintenance is included in all Quick Start 5-Packs. Subsequent years will be billed at the standard maintenance rate.
The first year annual software maintenance is required with license purchase.

BUY NOW

Download Evaluation

Register for a 15 Day Evaluation

For instant access to your trial of SQL Sentry Performance Advisor, Event Manager, and Fragmentation Manager for all supported platforms, please complete and submit the form below. You will receive instructions for gaining access to the unified setup package. The required license key will be sent via email, and will enable you to manage 5 Windows systems, 5 SQL Server instances, 2 Analysis Services instances, 2 SharePoint installations, and 5 Oracle databases. Please review the SQL Sentry system requirements prior to installation. For a larger trial, please contact us. If you have already registered through a previous download, you may go directly to My Account.

Check out Greg's blog for the latest on version 8.

* First Name:

* Last Name:

Phone:

* Company Name:

* Email Address:

* Country:

How did you hear about SQL Sentry?


Answer a few questions and extend your trial period:

Add 15 Days?

 

Answer a few questions and get 15 Days added to your evaluation!



Number of servers to monitor:
Number of people managing
your SQL Server environment?
Number of instances to monitor:
SQL Server Analysis Services
Oracle Windows

Which of your tasks are the most challenging?

What other software tools are you considering?

Do any of the following interest you?

(choose all that apply)

Solutions for SQL Server

SQL Server performance dashboard and multi-server monitoring
Real-time & historical troubleshooting and performance analysis
Storage system monitoring for activity, latency, & capacity
Index monitoring and management
High-availability monitoring for AlwaysOn, Mirroring, and Clustering
Top SQL tracking and analysis
Visualizing Top SQL, deadlocks, jobs failures, and other important events over time
Advanced job management, chaining, and queuing
Sophisticated alerting & conditional response for SQL Server conditions
Deep SQL tuning and performance analysis

Solutions for Business Intelligence

SSAS Performance dashboard and monitoring
Workload and Bottleneck Profiling
Capturing heavy MDX, XMLA, and DMX activity
Sophisticated alerting system for SSAS commands and runtime deviations
Monitoring SSAS Cache and storage systems
Visualizing SSAS, SQL Server, SSIS, SSRS, and SharePoint events over time
Sophisticated monitoring of SSIS data warehousing jobs and SSRS reports

Solutions for Windows Servers

Windows Performance Dashboard and Multi-server monitoring
Real-Time & Historical Troubleshooting and Performance Analysis
Sophisticated alerting & conditional response for Windows Tasks
Granular Windows process monitoring and analysis

Professional Services

Training for SQL Sentry products and best practices
Training for SQL Server / Windows technologies
Installation, configuration, and setup services
Troubleshooting, performance tuning, and optimization services
;