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»»»

Monitor Database Growth Expand / Collapse
Author
Message
Posted Sunday, September 23, 2007 11:38 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 4, 2006 7:05 AM
Points: 27, Visits: 1
Comments posted to this topic are about the item Monitor Database Growth
Post #401684
Posted Friday, October 19, 2007 4:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, February 3, 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
Posted Thursday, November 29, 2007 3:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, January 14, 2008 2:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 9:17 AM
Points: 4, Visits: 247
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
Posted Monday, February 4, 2008 10:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 9, 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
Posted Monday, February 4, 2008 2:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 9:17 AM
Points: 4, Visits: 247
That is how I have it.
Post #451359
Posted Thursday, March 13, 2008 1:05 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, November 7, 2014 6:03 PM
Points: 538, Visits: 1,929
hi for some reason i always get the growth size to be 0, do you have an updated script?
Post #468969
Posted Thursday, March 13, 2008 1:09 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, November 7, 2014 6:03 PM
Points: 538, Visits: 1,929
Has anyone been using this script and has been working for them?
Post #468974
Posted Friday, March 28, 2008 6:30 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 3:44 AM
Points: 1,260, Visits: 3,424
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!




============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #476034
Posted Thursday, April 10, 2008 7:59 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, December 15, 2014 5:40 PM
Points: 207, Visits: 350
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 »

Add to briefcase 123»»»

Permissions Expand / Collapse