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.