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 ...
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