Forum Discussion

ibk2510's avatar
ibk2510
Copper Contributor
Jan 27, 2023

Azure SQL DB Data growing constantly whenever truncate/delete load

I have an azure SQL DB where initially the data space used is 6gb. and there is a pipeline in data factory which truncate and load the SQL Tables(Full Load). But each day the data used is increasing constantly whenever the pipeline runs. i have checked the tables there is no duplicate records founds. Also i have checked the data space used by tables are around 6gb. im not sure from where the data keep on increasing.

1 Reply

  • bake13's avatar
    bake13
    Icon for Microsoft rankMicrosoft
    Feb 09, 2023

    Hi ibk2510 -- What is the log file size for the database?

     

    SELECT file_id,
name,
       CAST(FILEPROPERTY(name, 'SpaceUsed') AS bigint) * 8 / 1024. AS space_used_mb,
       CAST(size AS bigint) * 8 / 1024. AS space_allocated_mb,
       CAST(max_size AS bigint) * 8 / 1024. AS max_size_mb
FROM sys.database_files

Resources