Azure SQL DBSS_Azure_Database_Recommendations collection and Permissions Check fails in Foglight 5.9.8 and lower (4226342)

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

戻る

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

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

評価を選択

タイトル

Azure SQL DBSS_Azure_Database_Recommendations collection and Permissions Check fails in Foglight 5.9.8 and lower
説明
DBSS_Azure_Database_Recommendations collection and Permissions check are failing when compatibility level is set as 100 or lower (SQL Server 2008) in an Azure SQL database.

The following collections fail for the Azure SQL agent
- Blocking Current dashboard metrics
- SQL PI
- Unable to check the privileges for the Azure user
原因

SQL Server 2008 compatibility level below 100 will cause problems with the collections.
対策

WORKAROUND 1

Increase the compatibility level higher than 120.

Compatibility levels of 120 and below do not technically meet the requirements listed in the Deployment Guide because it effectively turns the Azure instance into a version below Azure v12.

WORKAROUND 2

Please contact Support for a hotfix for this issue for when compatibility level is set to SQL Server 2008 (100)

STATUS

This issue has was logged as defect FOG-1575 and has been fixed in the 6.0.0.10 version of the Azure SQL cartridge for Foglight.
Defect ID

FOG-1575

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

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

評価を選択

推奨コンテンツ

製品：: Foglight
5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2; Foglight Evolve
9.3, 9.2, 9.1, 9.0; Foglight for Databases
5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

タイトル