SnapCenter UIでのSQLリソースの更新に非常に時間がかかる
環境
- SnapCenterサーバ(SC)4.8
- SnapCenter Plug-in for Microsoft SQL Server(SCSQL)4.8
- Microsoft SQL Server Management Studio(SSMS)
問題
- SnapCenter UIでのSQLリソースの更新に非常に時間がかかる
- 問題の原因となっているSQLホストのSMSQL_SQL <Job_Id>ログには、次のメッセージが表示されます。
DEBUG SmSql_<Job_Id> PID=[3528] TID=[27] Fetching Database [__Verification__<DB_Id>] properties...
ERROR SmSql_<Job_Id> PID=[3528] TID=[27] Property DatabaseGuid is not available for Database '[__Verification__<DB_Id>]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
ERROR SmSql_<Job_Id> PID=[3528] TID=[27] Failed to get the details of database __Verification__<DB_Id>
ERROR SmSql_<Job_Id> PID=[3528] TID=[27] ErrorCode (-1), ErrorMessage (Property DatabaseGuid is not available for Database '[__Verification__<DB_Id>]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. )
DEBUG SmSql_<Job_Id> PID=[3528] TID=[27] Skipping verification database __Verification__<DB_Id> of sql instance <SQL_Instance>