Database Space Capacity Planning

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 Chad Miller » Database Space Capacity Planning

88 posts, Page 1 of 9

1 2 3 4 5 »»»

Database Space Capacity Planning

Rate Topic

Display Mode

Topic Options

Author

Message

cmille19

Posted Monday, October 12, 2009 10:47 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 5:01 AM
Points: 257, Visits: 674

Comments posted to this topic are about the item Database Space Capacity Planning

Post #801935

philcart

Posted Tuesday, October 13, 2009 12:12 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 2:22 AM
Points: 2,693, Visits: 1,081

Top stuff

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

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

Regan Galbraith

Posted Tuesday, October 13, 2009 1:55 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, June 10, 2013 9:28 AM
Points: 86, Visits: 253

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

Tim Reddish

Posted Tuesday, October 13, 2009 3:17 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, June 06, 2013 5:27 AM
Points: 1,085, Visits: 209

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

graeme.black

Posted Tuesday, October 13, 2009 3:51 AM

Grasshopper

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

shashi kant

Posted Tuesday, October 13, 2009 6:03 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:45 AM
Points: 162, Visits: 457

Supurb Article, I was looking for such article.
Do you have SQL Server 2000 scripts for the same

Regards
Shashi Kant Chauhan

Post #802088

cmille19

Posted Tuesday, October 13, 2009 6:07 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 5:01 AM
Points: 257, Visits: 674

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

smthembu

Posted Tuesday, October 13, 2009 8:13 AM

Right there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 11:11 PM
Points: 786, Visits: 752

That's good stuff

It's better to fail while trying, rather than fail without trying!!!

Post #802160

cmille19

Posted Tuesday, October 13, 2009 8:44 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 5:01 AM
Points: 257, Visits: 674

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

smthembu

Posted Tuesday, October 13, 2009 8:53 AM

Right there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 11:11 PM
Points: 786, Visits: 752

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 »

88 posts, Page 1 of 9

1 2 3 4 5 »»»

Permissions