Database Growth History

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Nicholas Williams » Database Growth History

24 posts, Page 1 of 3

1 2 3 »»»

Database Growth History

Rate Topic

Display Mode

Topic Options

Author

Message

Zksod

Posted Friday, February 06, 2009 5:10 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, November 19, 2012 2:53 AM
Points: 34, Visits: 171

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

Post #651522

gregory.anderson

Posted Thursday, February 12, 2009 6:27 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:10 AM
Points: 263, Visits: 429

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

gregory.anderson

Posted Thursday, February 12, 2009 6:32 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:10 AM
Points: 263, Visits: 429

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

Post #655619

Zksod

Posted Thursday, February 12, 2009 6:32 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, November 19, 2012 2:53 AM
Points: 34, Visits: 171

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

princess.lipscomb

Posted Thursday, February 12, 2009 7:59 AM

SSC 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

gregory.anderson

Posted Friday, February 13, 2009 8:33 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:10 AM
Points: 263, Visits: 429

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

Nick B.

Posted Friday, April 02, 2010 7:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 11:48 AM
Points: 6, Visits: 111

Hello,

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

Post #895625

Nick B.

Posted Friday, April 02, 2010 8:18 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 11:48 AM
Points: 6, Visits: 111

I'm good, thanks again for the script.

Post #895651

wakanni

Posted Monday, April 26, 2010 9:15 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:16 AM
Points: 1, Visits: 284

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

Post #910466

jackdonnell-684036

Posted Wednesday, July 21, 2010 8:38 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:46 AM
Points: 73, Visits: 115

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

Post #956893

« Prev Topic | Next Topic »

24 posts, Page 1 of 3

1 2 3 »»»

Permissions