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 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.
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 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
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.
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 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.
|SAVE 50% / $2,375.00
Fragmentation Manager Quick Start 5-Pack
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
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
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.