Avamar: SQL Backup encounters timeout due to insufficient resource allocation

Summary: The failure of SQL backups, resulting in a timeout end status, is attributed to the allocation of insufficient resources.

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

Following errors will be observed in the SQL backup logs in both GUI/AUI Activity Monitor and Client machine
Log location at SQL Client : 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.

Upon reviewing the performance metrics in the Task Manager for the SQL Client, it is clear that there is significant CPU utilization.
image.png

During our examination of processes that consume a significant amount of CPU and RAM, we have identified that there are other processes utilizing the maximum available resources.
 

Cause

The Avamar backup processes are failing to run, resulting in SQL backup failures. This issue is caused by the high CPU and RAM consumption from other server processes, such as SQL Server Windows NT.

Resolution

Engage the SQL/Wintel administration team to mitigate the usage of CPU and RAM by SQL Server and other Agent processes.

For further details, kindly refer to below articles :
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.