SQL Server Defrag & Index Analysis

Dramatically improves the manageability and visibility of SQL Server index fragmentation across the enterprise

Fragmentation Manager helps you make good decisions about how and when to defragment. You can easily set up an environment-wide schedule to automate index defragmentation operations, while allowing the flexibility to customize the schedule and other specific instances, databases, tables, and even individual indexes. Fragmentation Manager will also allow you to perform index defragmentation faster than ever before via support for multiple concurrent operations.

 

  • The integration with Performance Advisor allows you to assess the impact of SQL Server index fragmentation 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 SQL Server 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 SQL Server 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.

SQL Server 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.

 

Articles

June 2014

Fixes for SQL Server 2012 & 2014 Online Index Rebuild Issue

Aaron Bertrand warns about a parallelism bug found in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds. If you are in a situation where you can’t apply the 2012 or 2014 hot fixes that address the issue, then you can use Fragmentation Manager’s MAXDOP setting to bypass the bug.

December 2012

Trimming the Transaction Log Fat

Paul Randal discusses how the database’s transaction log can be a bottleneck that adds to the time it takes a transaction to complete. He also discusses how to identify fragmented indexes to ultimately help reduce transaction log usage.

August 2012

My Perspective: The Top 5 Most Common SQL Server Performance Problems

In this post, Jason Hall shares the top 5 SQL Server Performance issues that our Client Services team sees on daily basis. He discusses the problems with tempdb PAGELATCH contention, expecting auto update statistics to keep statistics updated, and more.

May 2012

SQL Sentry v7 goes Gold!

After what has been a relatively smooth beta, we're going gold with v7 today! Read more about v7 features in my last post. I've also got some exciting news regarding new fragmentation-related features included in the base software, and how to get FREE licenses of both Performance Advisor and Fragmentation Manager.

April 2012

SQL Sentry v7: With our new Fragmentation Manager module

7 represents the culmination of almost a year of effort, and ideas going back much, much further than that. We've completely redone several aspects of the software such as alerting (condition and action) configuration, and we've added some awesome new features like automated defrag, computer groups, and CMS support to boot. Did I mention SQL Server 2012?

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