Estimate the db files and log file growth

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

okbangas SSChampion Points: 11773 More actions · Answer 1

Look at the database and log backup size:

select

database_name,

type,

backup_finish_date,

backup_size

from

msdb.dbo.backupset

Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

Concatenating Row Values in Transact-SQL[/url]

RTaylor2208 SSChampion Points: 13298 More actions · Answer 2

Also have a look at the Standard reports in SSMS, right click on your database and select Reports > Standard Reports > Disk Usage.

Its not perfect but will show you any autogrows that occured on your DB.

Theres a number of factors where this may be of no use but it's worth a quick look.

MCITP SQL 2005, MCSA SQL 2012

R_S Ten Centuries Points: 1160 More actions · Answer 3

Look at the perfmon counters for SQLServer:Databases -

Data File(s) Size(KB)

Log File(s) Size(KB)

This would show you the growth of your data/log files.