growth of databases

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.

more ▼

asked Oct 11, 2017 at 02:26 AM in Default

avatar image

866 49 64 68

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Oct 11, 2017 at 03:23 AM

avatar image

25k 3 13 20

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 11, 2017 at 02:26 AM

Seen: 21 times

Last Updated: Oct 11, 2017 at 09:27 AM

Copyright 2018 Redgate Software. Privacy Policy