Data Domain: Windows SQL CIFS backups are slow after migration to new Data Domain
Summary: Data Domain: Windows SQL CIFS backups are slow after migration to new Data Domain
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.
Symptoms
SQL Backups transaction log backups take seconds to complete on the old Data Domain as compared an hour on the new data domain
Each SQL transaction log backup that is runs on the new data domain increases in duration with every subsequent backup
Only Windows SQL backup are affected linux or windows filesystem backups run at expected speed.
Similar errors seen in the ddfs.info log
05/29 15:00:39.333699 [7ff34e902b30] FM fm_dm1_lookup_by_handle:2865 - Open (stream) - file: /data/col1/mtree/SQL/transaction_log_name_timestamp.trn, fh: 43451d:0:21f2058:0:9cde1f46:65772d59:0:(0:99962), cd: 1482, flags: 8000008, ch : 1a00,1,0,400,6,0,c95cf072,8f864927,21831b89,9c84edd0,f321165e,8992a6ec, open_ch : 1a00,1,0,400,6,0,c95cf072,8f864927,21831b89,9c84edd0,f321165e,8992a6ec
05/29 15:00:39.342604 [7ff34e902800] ERROR: FM fm_make_open_structures:889 - fm_access_intern failed with errnum 5177
05/29 15:00:39.349694 [7ff34e902800] ERROR: FM fm_make_open_structures:909 - fm_access_delete failed for open with delete-on-close with 5177
05/29 15:00:39.353303 [7ff34e902800] ERROR: FM fm_make_open_structures:909 - fm_access_delete failed for open with delete-on-close with 5177
Wireshark capture was run on the SQL server
CIFS SMB file write operation from the backup is seen:
2854 0.978471 10.43.132.114 142.164.13.190 SMB2 588 Create Request File: mtree\SQL\transaction_log_name_timestamp.trn
Find and read operation after the file write is seen:
3556 1.253996 10.43.132.114 142.164.13.190 SMB2 166 Find Request File: mtree\SQL SMB2_FIND_BOTH_DIRECTORY_INFO Pattern: <.trn
Process Monitor was run on the SQL server
sqlserver.exe is seen with access denied on read requests for each transaction log in the destination directory as more backups complete more transaction logs get writen causing the backup time to increase
Each SQL transaction log backup that is runs on the new data domain increases in duration with every subsequent backup
Only Windows SQL backup are affected linux or windows filesystem backups run at expected speed.
Similar errors seen in the ddfs.info log
05/29 15:00:39.333699 [7ff34e902b30] FM fm_dm1_lookup_by_handle:2865 - Open (stream) - file: /data/col1/mtree/SQL/transaction_log_name_timestamp.trn, fh: 43451d:0:21f2058:0:9cde1f46:65772d59:0:(0:99962), cd: 1482, flags: 8000008, ch : 1a00,1,0,400,6,0,c95cf072,8f864927,21831b89,9c84edd0,f321165e,8992a6ec, open_ch : 1a00,1,0,400,6,0,c95cf072,8f864927,21831b89,9c84edd0,f321165e,8992a6ec
05/29 15:00:39.342604 [7ff34e902800] ERROR: FM fm_make_open_structures:889 - fm_access_intern failed with errnum 5177
05/29 15:00:39.349694 [7ff34e902800] ERROR: FM fm_make_open_structures:909 - fm_access_delete failed for open with delete-on-close with 5177
05/29 15:00:39.353303 [7ff34e902800] ERROR: FM fm_make_open_structures:909 - fm_access_delete failed for open with delete-on-close with 5177
Wireshark capture was run on the SQL server
CIFS SMB file write operation from the backup is seen:
2854 0.978471 10.43.132.114 142.164.13.190 SMB2 588 Create Request File: mtree\SQL\transaction_log_name_timestamp.trn
Find and read operation after the file write is seen:
3556 1.253996 10.43.132.114 142.164.13.190 SMB2 166 Find Request File: mtree\SQL SMB2_FIND_BOTH_DIRECTORY_INFO Pattern: <.trn
Process Monitor was run on the SQL server
sqlserver.exe is seen with access denied on read requests for each transaction log in the destination directory as more backups complete more transaction logs get writen causing the backup time to increase
Cause
As part of the backup command the CleanupTime SQL parameter was used.
This parameter makes a request to read and delete expired transaction backups in the destination mtree on the data domain.
The cifs user was not an admin user.
admin user is required to read/delete the old transaction logs on the data domain
The old data domain was using an admin user
The new data domain was using a default user
This parameter makes a request to read and delete expired transaction backups in the destination mtree on the data domain.
The cifs user was not an admin user.
admin user is required to read/delete the old transaction logs on the data domain
The old data domain was using an admin user
The new data domain was using a default user
Resolution
Make the cifs user an admin user on the data domainuser change role <user> admin
for exampleuser change role cifsuser admin
Affected Products
Data DomainArticle Properties
Article Number: 000226280
Article Type: Solution
Last Modified: 01 Nov 2024
Version: 1
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.