SQL Index Manager(英語版)
データベースのインデックスの断片化を分析、管理、修正
Redgate Software 社の製品
2005 年より日本国内にてComponentSourceで販売中。
価格:¥ 50,710 (税込)〜 バージョン: 1.1 更新日: Mar 20, 2017
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, get a full report on indexes across your databases, including severity of fragmentation and the reasons for it. Fix fragmentation, choose which indexes to fix based on fragmentation severity. Reorganize or rebuild, set which action to take, based on customizable rebuild and reorganization thresholds, and rebuild indexes online with SQL Server Enterprise Edition. Analyze over time, export the results of your analysis to track and report on fragmentation. Automatically generate T-SQL scripts to fix fragmentation.
Analyze individual databases, or multiple databases at once
Select your server and choose to scan and fix fragmentation on a specific database, all User databases, or all System databases.
You can also see the total time taken to complete the fragmentation scan.
Advice on rebuilding or reorganizing
See the suggested action, the reason for fragmentation, and the priority level for a fix.
If you use SQL Server Enterprise, you can also rebuild your indexes online.
Analyze and export fragmentation...
今すぐ Redgate Software ライセンススペシャリストとライブ チャット。