SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Sylvia Moestl Vasilik / An easy way to track the growth of your database / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 10:35:22 GMT20RE: An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspxIn the interim you could:select BackupDate = convert(varchar(10),backup_start_date, 111), SizeInGigs=CAST(round(backup_size/1073741824,4) AS decimal(18,4)),backup_size AS [Raw backup_size],CASE TYPEWHEN 'D' THEN 'Full'WHEN 'F' THEN 'Filegroup'WHEN 'I' THEN 'Differential'WHEN 'L' THEN 'Log'ELSE 'Unknown'END AS Typefrom msdb..backupset where database_name = 'ROOMBOOKING' --and type = 'D'order by backup_start_date DESCFri, 20 May 2011 07:07:32 GMTMichael.BeebyRE: An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspxHow could we modify the code to include the growth of the log file?Mon, 14 Sep 2009 11:45:12 GMTbpowersRE: An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspxnice script...i just added it to my DBA dashboard :-D...i already had another but this is betterFri, 21 Aug 2009 14:49:11 GMTYogesh RanadeRE: An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspxCan the same thing be accomplished in Microsoft Access?Mon, 08 Jun 2009 07:38:53 GMTrsloanRE: An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspx""""[i]what about the databases which are backed up with compression method like litespeed, let say today backup is taken with native method and tommorrow backup is taken with litespeed, how do we know[/i] """"If you use percentage growth - over the time periods not compressed and compressed periods it should be more or less the sameTue, 21 Apr 2009 22:32:09 GMTkbotha80RE: An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspxGreate Script. Usually peopel would like to see percentage growth which is easily calulate using this script of yours. Providing the Db always gorwos in size thsi will work. - Script great Idee :cool:Select ((MAX(SizeInGigs) - MIN(SizeInGigs))/ MAX(SizeInGigs))*100 from (select BackupDate = convert(varchar(10),backup_start_date, 111) ,SizeInGigs=floor(backup_size) from msdb..backupset where database_name = 'CES' and type = 'd')TBTue, 21 Apr 2009 22:29:58 GMTkbotha80RE: An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspxuse the figure 1048576 instead of 1024000000 or 1073741824.KB = 1024MB = 1024^2GB = 1024^3 so on and so forth.Fri, 27 Mar 2009 11:40:15 GMTmadyson3RE: An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspxHow would I modify this script to show the results in MB instead of GB?Fri, 20 Feb 2009 13:15:18 GMTJpotucekRE: An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspxwhat about the databases which are backed up with compression method like litespeed, let say today backup is taken with native method and tommorrow backup is taken with litespeed, how do we know whther databae size is increased or not.thanksJosephSun, 08 Feb 2009 11:07:42 GMTJoseph-465703RE: An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspxto apply this script to every database on the server try using this and modify the script as appropriate:http://www.sqlservercentral.com/scripts/Metadata/65453/Tue, 06 Jan 2009 23:16:19 GMTkodracon RE: An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspxGood article. I just found that using the floor function gave the size as 1 right through because the db that I work on is 1.6 gb so I rather used the round function and it came up tops. Thanks for a good article.Below is an example of what I did.select BackupDate = convert(varchar(10),backup_start_date, 111), SizeInGigs=round(backup_size/1024000000,4) from msdb..backupset where database_name = 'OrisysSql' and type = 'd'order by backup_start_date descWed, 07 May 2008 07:39:01 GMTManie VersterRE: An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspxNice script, except to convert bytes to gigabytes you need to divide it by 1073741824 BytesSee [url]http://www.123marbella.net/en/free-bandwith-calculator.html[/url]Wed, 07 May 2008 05:42:23 GMTDavid BirdRE: An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspxhi,I've just implented the script and think the result output is awesome.However i was wondering if there was any way within the script that it would include all databases on the server instead of one at at time, and to have a history on the size since it was first created. Also is there any way it could be executed as a job, if so what do you reckon the command will be, to run this in SQL AGENT agentie something similar to exec sp_track_db_growth "northwind" s an example Like i said the script was and is fantabulous!!!!!!!!!!!!!!!.CIAOvivcolli:DWed, 16 Apr 2008 04:47:41 GMTviv-488863An easy way to track the growth of your databasehttp://www.sqlservercentral.com/Forums/Topic467818-1224-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Backup/62497/">An easy way to track the growth of your database</A>[/B]Tue, 11 Mar 2008 16:57:42 GMTSylvia Moestl Vasilik