Solved

Estmating database size

Posted on 1998-08-07
4
403 Views
Last Modified: 2008-02-01
apparently, there is a procedure called sp_estspace and there is a microsoft version of it called estspace.sql which guides one through size estimation for a new database. could someone happen to know as to how to get it??
0
Comment
Question by:sajalk
  • 2
4 Comments
 
LVL 4

Expert Comment

by:mitek
ID: 1089472
Not in MS SQL 6.5. Are you talking about 7.0 ?
0
 

Author Comment

by:sajalk
ID: 1089473
i read about this in a book, and it is for 6.5. the sp_estspace procedure is the sybase version.
i would send a mail to the author to get some more informaion on it.

thanx much.
sajal.
0
 
LVL 2

Accepted Solution

by:
connex earned 50 total points
ID: 1089474
There is no such sql-file I know of. Never heard of it though.
But there is a good article in the SQL Server Ressource Guide
about Estimating Database Sizes.
(Head to support.mircosoft.com and search for
 "estimating database size sql")


0
 

Author Comment

by:sajalk
ID: 1089475
i have found it.

thanx very much.
sajal.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

707 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

16 Experts available now in Live!

Get 1:1 Help Now