SQL Index Manager 使你可以快速簡(jiǎn)單的發(fā)現(xiàn)你的索引的狀態(tài),而且發(fā)現(xiàn)哪一個(gè)數(shù)據(jù)庫(kù)需要維護(hù)。你可以通過(guò)用戶界面來(lái)選擇執(zhí)行維護(hù)任務(wù),還是通過(guò)SSMS來(lái)查看T-SQL腳本來(lái)運(yùn)行命令.
SQL Index Manager enables you to quickly and easily find out the status of your indexes and discover which databases need maintenance. You can then choose to perform the maintenance task required through the UI, or view the T-SQL script to execute the command via SSMS.
需要培訓(xùn)、定制、外包?
請(qǐng)聯(lián)系我們!:800018081
慧都專業(yè)技術(shù)團(tuán)隊(duì)幫助您提高效率,節(jié)省成本,降低風(fēng)險(xiǎn)!
* 關(guān)于本產(chǎn)品的分類與介紹僅供參考,精準(zhǔn)產(chǎn)品資料以介紹為準(zhǔn),如需購(gòu)買請(qǐng)先行測(cè)試。
特征
-
快速而簡(jiǎn)單的安裝
現(xiàn)在選擇你的服務(wù)器和數(shù)據(jù)庫(kù),然后點(diǎn)擊診斷,就可以開(kāi)始針對(duì)分片索引來(lái)分析你的數(shù)據(jù)庫(kù)。
-
可配置的分散閾值
分片索引和閾值大小可以被手動(dòng)被報(bào)告的分散化在哪一個(gè)水平上。
-
清晰的數(shù)據(jù)可視化
使用索引分析報(bào)告的結(jié)果來(lái)快速地識(shí)別高度分散化的索引。
-
重建或重組上的建議
查看分片水平,得到是否重建或者重組索引的建議 。
然后在特定的索引上改正問(wèn)題,或者選擇來(lái)全部修正。
-
一鍵維護(hù)
只要通過(guò)一個(gè)單擊就開(kāi)始重建或者重組被選擇的索引。
-
自動(dòng)生成T-SQL腳本
SQL Index Manager 能夠生成T-SQL 腳本,或者創(chuàng)建一個(gè)SQL Server工作,來(lái)重建或者重組你的索引。
-
實(shí)時(shí)反饋
實(shí)時(shí)查看SQL Index Manager重建或者重組了哪些索引。
Features
Quick and easy setup

Choose your server and database and click Diagnose now to begin analyzing your database for fragmented indexes.
Configurable fragmentation thresholds

The index fragmentation and size thresholds can be manually specified to set the levels at which fragmentation is reported.
Clear data visualization

Quickly identify highly-fragmented indexes using the results in the Index Analysis report
Advice on rebuilding or reorganizing

View fragmentation levels and get recommendations on whether to rebuild or reorganize indexes.
Then fix problems with specific indexes, or choose to correct all of them.
One-click maintenance

Start rebuilding or reorganizing selected indexes with a single click.
Automatic T-SQL script generation

SQL Index Manager can generate T-SQL scripts, or create a SQL Server Job, to rebuild or reorganize your indexes.
Real-time feedback

See which indexes SQL Index Manager has rebuilt or reorganized in real time.