SCSQL备份似乎速度较慢

最后更新
另存为PDF

Views:

Visibility:: Public

Votes:: 0

Category:: snapcenter

Specialty:: snapx

Last Updated:

适用场景

适用于SQL 5.0P1的SnapCenter插件(SCSQL)

SnapCenter服务器(SC)

问题描述

SCSQL备份速度较慢、需要几分钟时间、SC UI才会将作业显示为正在运行。

在SCSQL环境发现过程中、所需时间远远超过预期、因为执行某些WMI查询需要20秒、而提取数据库属性需要50秒。

从备份作业日志中的SmSql_123.log：

2024-07-03T17:39:33.8386294+02:00 DEBUG SmSql_123 PID=[6124] TID=[32] Resource: SELECT * FROM MSCLUSTER_RESOURCE WHERE Type = "Network Name" 2024-07-03T17:39:54.6512109+02:00 DEBUG SmSql_123 PID=[6124] TID=[32] searcher->Get() complete

2024-07-03T17:39:54.7293430+02:00 DEBUG SmSql_123 PID=[6124] TID=[32] Resource: SELECT * FROM MSCLUSTER_RESOURCE WHERE Type = "SQL Server" 2024-07-03T17:40:15.4637909+02:00 DEBUG SmSql_123 PID=[6124] TID=[32] searcher->Get() complete

2024-07-03T17:42:24.3830339+02:00 DEBUG SmSql_123 PID=[6124] TID=[13] Fetching Database [DB1] properties... 2024-07-03T17:43:14.6038094+02:00 DEBUG SmSql_123 PID=[6124] TID=[13] FillAGDetails

2024-07-03T17:43:14.6819346+02:00 DEBUG SmSql_123 PID=[6124] TID=[13] Fetching Database [model] properties...

2024-07-03T17:44:04.9016294+02:00 DEBUG SmSql_453 PID=[6124] TID=[13] FillAGDetails