Index Fragmenation script QS_Fraginfo.sql running outside its scheduled period. (4220863)

サポートと今すぐチャット

戻る

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

タイトル

Index Fragmenation script QS_Fraginfo.sql running outside its scheduled period.
説明

Is there a way to determine what prompted QS_FragInfo.sql, which is responsible for Index Fragmentation collection, to run on one of our monitored instances outside the period it was scheduled for?
対策

WORKAROUND:
Disable this collection if script execution is causing a performance issue on monitored instance. To disable this collection, from Configure | Scheduling option, select the monitored connection and locate Fragmentation Overview collection. Disable 'Collect data when Spotlight is not connected' option.
STATUS:
Issue fixed in the current release of Spotlight on SQL Server Enterprise. Latest version of Spotlight can be downloaded from here.
Defect ID

SOSSE-6293
追加情報

This script runs when user opens Index Fragmentation drilldown. Product change to optimize script.

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

推奨コンテンツ

製品：: Spotlight on SQL Server Enterprise
12.2, 12.1, 12.0.1, 12.0, 11.7.1, 10.0.1

タイトル