Total Transaction Log Size in Simple Recovery Model
In SQLServer 2008R2, checking the size the transaction log backups with in a certain time range will tell you the total size of transaction logs files generated within that time range. This works perfectly if the database's recovery model is full. However, we are not taking any transaction log backups if the database is in simple recovery model. So, how can we know the total size of the transaction logs generated if the database is in simple recovery model? Thanks for your help in advance.
You can't really. So instead, you could look at transactions/sec counter in Performance Monitor. You could also capture query metrics to see transactions and have a count that way. I prefer extended events for this when working on 2008 or better.