Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Database Growth History Expand / Collapse
Author
Message
Posted Friday, February 6, 2009 5:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 8:41 AM
Points: 39, Visits: 275
Comments posted to this topic are about the item Database Growth History
Post #651522
Posted Thursday, February 12, 2009 6:27 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 8, 2014 7:12 AM
Points: 263, Visits: 443
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...
Post #655611
Posted Thursday, February 12, 2009 6:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 8, 2014 7:12 AM
Points: 263, Visits: 443
Nevermind, guess I should actually look at the script and analyze it then I could answer the question myself....(NoSampleDays....). Woops!
Post #655619
Posted Thursday, February 12, 2009 6:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 8:41 AM
Points: 39, Visits: 275
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.
Post #655620
Posted Thursday, February 12, 2009 7:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, February 14, 2011 10:13 AM
Points: 25, Visits: 169
This is great information and easy to understand.

I have used it on over 100 of the 2000 dbs that I review
Post #655726
Posted Friday, February 13, 2009 8:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 8, 2014 7:12 AM
Points: 263, Visits: 443
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.
Post #656677
Posted Friday, April 2, 2010 7:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 11:48 AM
Points: 8, Visits: 111
Hello,

I am a beginner but this code is quite helpful, thanks a bunch.
Post #895625
Posted Friday, April 2, 2010 8:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 11:48 AM
Points: 8, Visits: 111
I'm good, thanks again for the script.
Post #895651
Posted Monday, April 26, 2010 9:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 12:28 PM
Points: 1, Visits: 320
Hello, when running this script am getting an 'Incorrect syntax near '-' error message. Any ideas?
Post #910466
Posted Wednesday, July 21, 2010 8:38 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 19, 2014 9:15 PM
Points: 131, Visits: 124
Thanks for the script! Might want to adapt it to use the sp_MSForeachDB for simplicity. Thanks again!
Post #956893
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse