During the archiving job the files are processed very slowly and there is a delay between entries in debugview of ~4 seconds before a new file is processed or a SQL timeout error occurs.
原因
Missing ACL indexes on SQL
解决办法
create nonclustered index IX_PAM_FS_DOCUMENT_ACL_ID on [dbo].[PAM_FS_DOCUMENT] ([ACL_ID]) create nonclustered index IX_PAM_FS_DOCUMENT_VER_ACL_ID on [dbo].[PAM_FS_DOCUMENT_VER] ([ACL_ID]) create nonclustered index IX_PAM_FS_FOLDERS_ACL_ID on [dbo].[PAM_FS_FOLDERS] ([ACL_ID]) create nonclustered index IX_PAM_FS_ACL_HASH on [dbo].[PAM_FS_ACL] ([HASH])