my boss wants to know the growth of the databases over time that i can provide it.
He wants to know if it has grown by 1 gig. There is a bunch of dbs anyone have thought on this as what i am coming up with isn't code i need and i'm on time crunch because of course they can't decide they need this and give us any time to do it correctly.
asked Oct 11, 2017 at 02:26 AM in Default
if it has grown by 1 gig since when? Do you actively track database size? If not, you'll have to be creative to get this. Maybe you have databases backups? You can use RESTORE FILELISTONLY to view what the database size was at a given time (or check msdb.dbo.backupfile, if you have enough backup history).
Most monitoring tools will track database size over time. If you don't have a dedicated tool, maybe start dumping sys.master_files into a table of your own to track this over time. It's a great way to make space projections when its time to budget for new storage.