September 3, 2019 at 6:52 am
Hi Experts,
Our log backup is growing very huge at times and we think it is because of a log table which is growing at a very high rate but why the log file?
I ran the below SQL and got the insert count as 113805077 but the table only have 1659919 records.
SELECT ios.object_id, object_name(ios.object_id, ios.database_id) object_name,
leaf_insert_count insert_count,
leaf_update_count update_count,
leaf_delete_count delete_count,
range_scan_count select_count
FROM sys.dm_db_index_operational_stats (18, NULL, NULL, NULL) ios
join appointdb.sys.objects o on ios.object_id = o.object_id
where ios.index_id in (0, 1)
and o.type = 'U' and o.is_ms_shipped = 0
Where I need to look? What am I missing here?
September 3, 2019 at 9:16 am
Is the database in full recovery mode? Do you have log backups running? How often are the log backups running? The log file is just your transactions, cumulative, so it's all about what you're doing to the system. Here's more information on this (also read the comments where a couple of details are corrected).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply