SQL Defrag Manager

Lokalisera och administrera SQL fragmentationer

boxshot sqldefragmanager

Den här e-postadressen skyddas mot spambots. Du måste tillåta JavaScript för att se den. VIDEO

SQL Defrag Manager är en deframenteringslösning för Microsoft Server

-Automatisera identifiering av index fragmenterade "hot spots"
-Schemalägga index defragmentering jobb
databas påstående med systemresurs pre-kontroller
-Minska antalet splittade sidor med index faktorinställningar
hantera, rapportera och anmäla i realtid



screenshot sqldefragmanagerIdentify Index Fragmentation
As index fragmentation increases over time, performance degrades, response times slow, and I/O suffers. SQL defrag manager performs an automated analysis of key metrics related to fragmentation to quickly pinpoint those areas where fragmentation is severely hindering performance, then triggers corrective measures.

Schedule Jobs
Manage the defragmentation process through scheduling of jobs at the most optimal time and based on the size of the index. Automate remediation and run the defragmentation utility immediately or during off-peak hours.

Avoid Contention
Check the utilization of key system indicators prior to execut­ing the defragmentation. This ensures that the policy is able to run as scheduled and avoid any potential system problems or application bottle­necks.

Manage Fill Factor
Most solutions don’t pay attention to the fill factor of tables, this can be a big drawback. With SQL defrag manager, users can manage index fill-factor settings and reduce splitting and shifting of pages as well as defrag job frequency.

Centralized management
The global dashboard displays all the SQL servers in your environment from one console, each database is color coded to reflect how much impact fragmentation is having on it, its databases, tables and indexes. You can easily sort to bring the items most in need of your attention to the forefront and take corrective action.



Customizable Defragmentation Control
Defrag processes can be triggered by fragmentation percentage or scan density, and prioritized based on fragmentation level, scan density, or index size. Additionally, defrag operations can be limited to the “top x” worst indexes, or by a “hard stop” time.

Policy-based Management
Defragmentation policies can be applied at the server, database or index level to apply the same defragmentation management policy to multiple objects all at once. Changing the policy changes the defragmentation approach across all objects simultaneously.

Index Management
Specify how much free space SQL Server should leave on an index page via the fill factor settings to limit page splitting and shifting. This helps you to decrease the frequency of your index rebuilds and improve the performance and availability of your SQL server applications.

Proactive System Resource Checks
Ascertain the utilization of key system resources prior to executing the defragmentation utility. If the metric is at a customer defined threshold, the execution of the defrag operation will either be delayed, prevented or run as scheduled.

Learn more


Tekniska Specifikationer

Management Console
-Windows 2000 SP4, Windows XP SP3, Windows Server 2003 SP2, Windows 2008 SP1, Windows Vista SP2+, Windows 7 SP1+, Windows 2008 R2, Windows 8, Windows 2012
-Microsoft .NET 2.0 SP1

Management Server and Data Repository
-Windows 2000 SP4, Windows XP SP3, Windows Server 2003 SP2, Windows 2008 SP1, Windows Vista SP2+, Windows 7 SP1+, Windows 2008 R2, Windows 8, Windows 2012
-Microsoft .NET 2.0 SP1
-Repository: SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014

Supported SQL Server Environments (for defragmentation)
-SQL Server 2000 and SQL Server 2005
-SQL Server 2008 R2
-SQL Server 2012
-SQL Server 2014


SQL Defrag Manager is offered per instance. A license is needed for each (per) SQL Server instance that is being monitored.  First year of maintenance is included in price.

Alfasoft offer a price guarantee for the IDERA products. If you find an IDERA product at a lower price before your purchase somewhere else we will match it.