Refresh of SQL resources in SnapCenter UI takes very long
Applies to
- SnapCenter Server (SC) 4.8
- SnapCenter Plug-in for Microsoft SQL Server (SCSQL) 4.8
- Microsoft SQL Server Management Studio (SSMS)
Issue
- Refreshing of SQL resources in the SnapCenter UI takes very long
- The following messages can be seen in the SmSql_<Job_Id> log for the SQL host that is causing the issue:
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>