Monitor Database Growth

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 Brandie Tarvin » Monitor Database Growth

23 posts, Page 1 of 3

1 2 3 »»»

Monitor Database Growth

Rate Topic

Display Mode

Topic Options

Author

Message

Brandie Tarvin

Posted Sunday, September 23, 2007 11:38 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 04, 2006 7:05 AM
Points: 27, Visits: 1

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

Post #401684

Sunil Telikicharla-457463

Posted Friday, October 19, 2007 4:08 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, February 03, 2013 10:22 PM
Points: 18, Visits: 114

The script looks very handy. But i have a small doubt. I am getting the orig size and current size as the same values and as such growth rate is coming up as 0.

Can you guide me on this.

Post #412658

itmastera

Posted Thursday, November 29, 2007 3:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 29, 2007 4:16 AM
Points: 1, Visits: 1

I think that script have a little mistake. Field size in table sys.master_files contains current filesize in 8-KB pages. So, this part of script is not right:Sum(Convert(decimal(10,2),tds.Size)) * 8000)/1024)/1024. Author wants to get file size in MB, but it must be like this: Sum(Convert(decimal(10,2),tds.Size)) * 8192)/1024)/1024. But the easiest way to get file size in MB is to write this: Sum(Convert(decimal(10,2),tds.Size)) * 8/1024

Post #427318

Aseda

Posted Monday, January 14, 2008 2:39 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 8:48 AM
Points: 4, Visits: 245

Can someone tell me why this script always gives the growth amount as 0 even when the origsize and cursize are significantly different.

Post #442700

drama1908

Posted Monday, February 04, 2008 10:30 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 09, 2008 1:34 PM
Points: 1, Visits: 20

For SQL 2000 in part two, you need to make the following changes:
1. Change all references database_id to dbid
2. Change all references to file_id to fileid
3. Change all references to sys.master_files to master.dbo.sysaltfiles
4. Change all references to sys.databases to master.dbo.sysdatabases

Post #451252

Aseda

Posted Monday, February 04, 2008 2:30 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 8:48 AM
Points: 4, Visits: 245

That is how I have it.

Post #451359

DBA-640728

Posted Thursday, March 13, 2008 1:05 PM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:21 PM
Points: 496, Visits: 1,724

hi for some reason i always get the growth size to be 0, do you have an updated script?

Post #468969

DBA-640728

Posted Thursday, March 13, 2008 1:09 PM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:21 PM
Points: 496, Visits: 1,724

Has anyone been using this script and has been working for them?

Post #468974

Dugi

Posted Friday, March 28, 2008 6:30 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

why the discussion is offline, since we are asking about any updates on this script!

plz tell us someone ( do you find any alternative solution or not ?!)

thnx!

w00t

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post #476034

David Masterson

Posted Thursday, April 10, 2008 7:59 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 03, 2012 12:05 AM
Points: 207, Visits: 294

Has anyone managed to get this script to run correctly?

"Ask me your questions, bridgekeeper. I'm not afraid"

Post #483378

« Prev Topic | Next Topic »

23 posts, Page 1 of 3

1 2 3 »»»

Permissions