Avamar：由于资源分配不足，SQL 备份遇到超时

Summary: SQL 备份失败导致超时结束状态，这是由于分配的资源不足所致。

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

在 GUI/AUI 活动监视器和 SQL 客户端的客户端计算机
日志位置的 SQL 备份日志中将观察到以下错误：C：/Program Files/avs/var/SxOMxxxxx_SQL1_hpxxn_uxxmdb_test_SQL_Schedule-test_SQL_Backups-1722556800070-3006-SQL.log

2024-08-02 08:20:38 avsql Info <6688>: Process 17036 (C:\Program Files\avs\bin\avtar) finished (code 0: success)
2024-08-02 08:20:38 avsql Info <6446>: SQL VDI transfer of 'SxOMxxxxx\SQL1/hpxxn_uxxmdb/f-0.hpxxn_uxxmdb' to 'SxOMxxxxx_SQL1_hpxxn_uxxmdb_test_SQL_Schedule-test_SQL_Backups-1722556800070-3006-SQL' successful
2024-08-02 08:20:38 avsql Error <40258>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Write on "SxOMxxxxx_SQL1_hpxxn_uxxmdb_test_SQL_Schedule-test_SQL_Backups-1722556800070-3006-SQL" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)
 
A nonrecoverable I/O error occurred on file "SxOMxxxxx_SQL1_hpxxn_uxxmdb_test_SQL_Schedule-test_SQL_Backups-1722556800070-3006-SQL:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
 
BACKUP DATABASE is terminating abnormally.

在 SQL 客户端的任务管理器中查看性能指标后，很明显，CPU 利用率很高。
image.png

在检查消耗大量 CPU 和 RAM 的进程期间，我们发现还有其他进程利用最大可用资源。
 

Cause

Avamar 备份进程无法运行，导致 SQL 备份失败。此问题是由其他服务器进程（如 SQL Server Windows NT）的高 CPU 和 RAM 消耗引起的。

Resolution

联系 SQL/Wintel 管理团队，以减少 SQL Server 和其他代理进程对 CPU 和 RAM 的使用。

有关更多详细信息，请参阅以下文章：
Article Properties
Article Number: 000227635
Article Type: Solution
Last Modified: 25 Jul 2025
Version:  3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.