Capacity planning and growth estimation

Posted on 2006-05-03
Last Modified: 2008-02-26
1) We are having SQL Server 2000 hosted on Windows 2000 server.

2) Can you elaborate on different ways to do Capacity planning and growth estimation for an SQL Server database i.e. each individual object, the main ones being tables and indexes.

3) In oracle & db2, we have it from built-in/third party tools GUI, formulas, average free space in block/page, average no. of rows & their increment in a specified interval.

4) Please post links or mail docs to {email address removed by Callandor} if it is difficult to fit here.
Question by:k_murli_krishna
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    you can use sp_spaceUsed 'objectName'

    This example reports the amount of space allocated (reserved) for the titles table, the amount used for data, the amount used for index(es), and the unused space reserved by database objects.

    USE pubs
    EXEC sp_spaceused 'titles'
    LVL 75

    Accepted Solution


    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now