Database Growth History

Question

Database Growth History

zNick

SSC Eights!

Points: 842
More actions
February 6, 2009 at 5:10 am

#199913

Comments posted to this topic are about the item Database Growth History

Viewing 15 posts - 1 through 15 (of 27 total)

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

andegre SSCertifiable Points: 5875 More actions · Answer 1

Question about this script, what is the "DataGrowth" value? I would assume that it's how much the database has "grown" since (when)? I have a database that is 400GB that I know 2 years ago was around 200GB, but the "DataGrowth" value only says 24.5GB.

Any help would be great! By the way, I do really like the script and I will find a use for it.

Thanks for the sharing...

andegre SSCertifiable Points: 5875 More actions · Answer 2

Nevermind, guess I should actually look at the script and analyze it then I could answer the question myself....(NoSampleDays....). Woops!

zNick SSC Eights! Points: 842 More actions · Answer 3

Hmm, that is interesting. What is the value of the SampleDays column?

I am glad that you found some use for it... 😉

edit:

Ah, I see you are a bit ahead of me there.

princess.lipscomb Say Hey Kid Points: 669 More actions · Answer 4

This is great information and easy to understand.

I have used it on over 100 of the 2000 dbs that I review

andegre SSCertifiable Points: 5875 More actions · Answer 5

A little tidbit that I found out about this script (and others that I run daily). This script appears to track data from when the SQL Server instance was installed, whereas, my other scripts that track index information get reset after each SQL Server reboot/recycle.

I was unfortunate enough to get to find that out today...

Thanks again for the script.

Nick B. SSC Veteran Points: 200 More actions · Answer 6

Hello,

I am a beginner but this code is quite helpful, thanks a bunch.

Nick B. SSC Veteran Points: 200 More actions · Answer 7

Nick B.

SSC Veteran

Points: 200

April 2, 2010 at 8:19 am

#1144778

I'm good, thanks again for the script.

wakanni SSC Rookie Points: 31 More actions · Answer 8

Hello, when running this script am getting an 'Incorrect syntax near '-' error message. Any ideas?

jackdonnell-684036 Old Hand Points: 315 More actions · Answer 9

Thanks for the script! Might want to adapt it to use the sp_MSForeachDB for simplicity. Thanks again!

SQLDCH SSChampion Points: 11635 More actions · Answer 10

Thanks for the script. Found a slight problem though: with database names that have funky characters in them, especially a period, this will throw an error (as wakanni found). I placed brackets around the @vcDatabaseName in the EXEC statement:

EXEC ('

INSERT INTO ##tbl_DataSize

SELECT CAST((SUM(size)) as DECIMAL(20,3)) FROM ['+@vcDatabaseName+'].dbo.sysfiles'

)

No more errors for me.

----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------

Yeah, well...The Dude abides.

rituchaudhary.work SSC Journeyman Points: 97 More actions · Answer 11

Hi,

I ran the script and it was giving desired results but in some of the servres it threw the below error:

Msg 207, Level 16, State 1, Line 89

Invalid column name 'size'.

Any idea how to get rid of this?

andegre SSCertifiable Points: 5875 More actions · Answer 12

rituchaudhary.work (11/7/2012)
Hi,
I ran the script and it was giving desired results but in some of the servres it threw the below error:
Msg 207, Level 16, State 1, Line 89
Invalid column name 'size'.
Any idea how to get rid of this?

Without doing any testing, I'm assuming the fix for this would be to throw brackets around your column name, since "size" is probably a reserved word in SQL Server.

rituchaudhary.work SSC Journeyman Points: 97 More actions · Answer 13

Hi,

thanks for the prompt reply but no good..I ran the query after adding the brackets but still got the same error..while the query is running fine on another server of the same version and edition. I am unable to make out where the fault is..

andegre SSCertifiable Points: 5875 More actions · Answer 14

rituchaudhary.work (11/8/2012)
Hi,
thanks for the prompt reply but no good..I ran the query after adding the brackets but still got the same error..while the query is running fine on another server of the same version and edition. I am unable to make out where the fault is..

What version of SQL Server are you running?