November 19, 2024 at 2:51 am
For MSSQL is there any queries or methods for me to pull historical data of transaction logs generation?
I know that for Oracle database we can run a query to extract the amount of archivelogs generated hourly/daily.
Is it possible for MSSQL? I have an hourly TLog backups running on the database, so currently I'm using this as a benchmark but is there any other way?
November 19, 2024 at 5:13 am
SQL captures the size of backups in table msdb.dbo.backupset. Thus, you can query that table to add up total space used for backups.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 19, 2024 at 4:08 pm
The size of your log backups over time are a very good indicator as to how much stuff is passing through the logs.
"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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply