by XDK
7. September 2014 18:57
Explanation:
- If your Files table is large:
EXEC prc_DeleteUnusedFiles 1, 0, 100
@partitionId = 1, @chunkSize=100
The nature of prc_deleteunusedfiles is that once it deletes a bunch of files, that causes more files to be able to be deleted due to our delta chains. This procedure is run on a weekly schedule so it will clean up the next set of files the next time the job runs. This procudure can executed repeatedly until FWFilesToDelete stops decreasing.This procedure may run for a long time, that’s why it has the third parameter which defines the batch size.
- If your Content table is large:
EXEC prc_DeleteUnusedContent 1
@partitionId = 1
- Queries to monitor the DB size
SELECT COUNT(*) FROM tbl_File f WHERE f.PartitionId = 1 AND f.OwnerId = 1 AND f.DeletedOn IS NULL AND f.CreationDate < DATEADD(DAY, -1, GETUTCDATE())
AND f.FileId NOT IN (SELECT FileId FROM tbl_Version WHERE PartitionId = 1 AND FileId IS NOT NULL)
SELECT COUNT(*) from tbl_File f WHERE f.DeletedOn IS NOT NULL
13becb95-bcac-4f65-a071-973f795066f8|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags:
Subscribe