[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Capacity planning and growth estimation

Posted on 2006-05-03
3
Medium Priority
?
501 Views
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.
0
Comment
Question by:k_murli_krishna
  • 2
2 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 16598578
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'
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 400 total points
ID: 16598618
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

873 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