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

Database Space Capacity Planning Expand / Collapse
Author
Message
Posted Monday, October 12, 2009 10:47 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:49 AM
Points: 258, Visits: 700
Comments posted to this topic are about the item Database Space Capacity Planning


Post #801935
Posted Tuesday, October 13, 2009 12:12 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:01 AM
Points: 2,693, Visits: 1,173
Top stuff

Now for SQL Server 2000, I would do ...


Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #801952
Posted Tuesday, October 13, 2009 1:55 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, July 28, 2013 3:59 PM
Points: 86, Visits: 255
Interesting stuff. we have something similar using SQL agent jobs, and SSRS.

Unless I missed it, the prediciton doesn't seem to have methods for predicting impact of reindexing and check database activities. Do you have metrics for establishing the peak DB size, or else of predicting the space required for that? We find that it is during the maintenance that our space alerts (85%, 90% etc.) most commonly trigger.

Post #802002
Posted Tuesday, October 13, 2009 3:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:36 AM
Points: 1,085, Visits: 269
Unless I'm mistaken the script to create the stored procedures in not present in the download.
Is this just me or has anyone else noticed?
Post #802028
Posted Tuesday, October 13, 2009 3:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 04, 2010 4:21 AM
Points: 12, Visits: 44
Yes the script for the stored procedures is missing from the downloads
Post #802046
Posted Tuesday, October 13, 2009 6:03 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 3:00 AM
Points: 162, Visits: 500
Supurb Article, I was looking for such article.
Do you have SQL Server 2000 scripts for the same

Regards
Shashi Kant Chauhan
Post #802088
Posted Tuesday, October 13, 2009 6:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:49 AM
Points: 258, Visits: 700
Somehow I left out the two creation statements for the procedures from the download. The definition for both procedures db_space_capacity_sp and vol_space_capacity_sp are included in the article. I've corrected the download to include the file spacedm.procedures.sql. It may take a few days for the update to be published. I've also uploaded a corrected download to my blog, here


Post #802090
Posted Tuesday, October 13, 2009 8:13 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, April 11, 2014 3:13 AM
Points: 923, Visits: 859
That's good stuff




It's better to fail while trying, rather than fail without trying!!!
Post #802160
Posted Tuesday, October 13, 2009 8:44 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:49 AM
Points: 258, Visits: 700
shashi kant (10/13/2009)
Supurb Article, I was looking for such article.
Do you have SQL Server 2000 scripts for the same

Regards
Shashi Kant Chauhan


The code works and has been tested against 2000, 2005 and 2008 servers. The backend repository must be 2005 or 2008. If you don't have a 2005 or 2008 SQL Server, SQL Express will work. Additionally the only pieces that are 2005/2008 specific are the CTEs used in the forecasting procedures. If you really want to use a 2000 repository you could rewrite these queries to uses subqueries instead of CTEs. The other piece that is 2008 specific are the SSRS reports. The reports are very basic and could be re-created using the SSRS wizard for 2000 or 2005 SSRS. Here again a SQL 2008 Express with Advanced Services (includes SSRS) would suffice.



Post #802191
Posted Tuesday, October 13, 2009 8:53 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, April 11, 2014 3:13 AM
Points: 923, Visits: 859
Hi

When i execute spaceanalysis.job it fails with the below or is it me

Msg 206, Level 16, State 2, Procedure sp_add_jobstep, Line 0
Operand type clash: int is incompatible with uniqueidentifier





It's better to fail while trying, rather than fail without trying!!!
Post #802198
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse