在SnapCenter UI中刷新SQL资源需要很长时间

最后更新
另存为PDF

Views:: 3

Visibility:: Public

Votes:: 0

Category:: snapcenter

Specialty:: snapx<a>2009年585092</a>

Last Updated:

适用场景

SnapCenter服务器(SC) 4.8
适用于Microsoft SQL Server的SnapCenter插件(SCSQL) 4.8
Microsoft SQL Server Management Studio (SSMS)

问题描述

在SnapCenter UI中刷新SQL资源需要很长时间
在引发问题描述的<Job_Id>主机的SMSQL_SQL日志中可以看到以下消息：

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>