Estimating the Size and Growth of a Database / Table

I have been looking for a copy of a tool called the 'data sizer' that could
be found in the Microsoft BackOffice 4.5 Resource Kit. I have had no luck
tracking it down.
What I would like is a tool / script / stored proc that would allow me to
estimate how large a database would be and what the growth potential may be.
If anyone has anything they could share I would appreciate it.
Thanks,
SniperX
> What I would like is a tool / script / stored proc that would allow me to
> estimate how large a database would be and what the growth potential may
be.
> If anyone has anything they could share I would appreciate it.
If you have Books Online installed, see these topics:
Estimating the Size of a Table with a Clustered Index
Estimating the Size of a Table Without a Clustered Index
sql

Estimating the Size and Growth of a Database / Table

I have been looking for a copy of a tool called the 'data sizer' that could
be found in the Microsoft BackOffice 4.5 Resource Kit. I have had no luck
tracking it down.
What I would like is a tool / script / stored proc that would allow me to
estimate how large a database would be and what the growth potential may be.
If anyone has anything they could share I would appreciate it.
Thanks,
SniperX> What I would like is a tool / script / stored proc that would allow me to
> estimate how large a database would be and what the growth potential may
be.
> If anyone has anything they could share I would appreciate it.
If you have Books Online installed, see these topics:
Estimating the Size of a Table with a Clustered Index
Estimating the Size of a Table Without a Clustered Index

Estimating the Size and Growth of a Database / Table

I have been looking for a copy of a tool called the 'data sizer' that could
be found in the Microsoft BackOffice 4.5 Resource Kit. I have had no luck
tracking it down.
What I would like is a tool / script / stored proc that would allow me to
estimate how large a database would be and what the growth potential may be.
If anyone has anything they could share I would appreciate it.
Thanks,
SniperX> What I would like is a tool / script / stored proc that would allow me to
> estimate how large a database would be and what the growth potential may
be.
> If anyone has anything they could share I would appreciate it.
If you have Books Online installed, see these topics:
Estimating the Size of a Table with a Clustered Index
Estimating the Size of a Table Without a Clustered Index

Estimating growth of mdf file size...

Hi, how can I estimate the mdf file size's growth as record inserted?

For a rough calculation you can calculate the sum of bytes needed for one row, e.g. Having a table with three CHAR(200) will need 600 bytes + additional overhead ~32 bytes. You can just sum up all the data types you have to get the row size in your table.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Thank you for replying.

Then, what about the growth if the table has index column?|||You will have to add the size of the indexed columns in addition.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Estimating growth

h
how can i find the below from database
Average Record Size (KB)
Total Master Table Storage (GB
Index Storage for 1 Record
Regard
RahLook up the chapter "Estimating the size of a database" in SQL Server 2000
Books Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rah" <anonymous@.discussions.microsoft.com> wrote in message
news:811C9279-BEE1-43FA-9085-B3BD63A8FC61@.microsoft.com...
hi
how can i find the below from database.
Average Record Size (KB)
Total Master Table Storage (GB)
Index Storage for 1 Record
Regards
Rah

Estimating growth

hi
how can i find the below from database.
Average Record Size (KB)
Total Master Table Storage (GB)
Index Storage for 1 Record
Regards
RahLook up the chapter "Estimating the size of a database" in SQL Server 2000
Books Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rah" <anonymous@.discussions.microsoft.com> wrote in message
news:811C9279-BEE1-43FA-9085-B3BD63A8FC61@.microsoft.com...
hi
how can i find the below from database.
Average Record Size (KB)
Total Master Table Storage (GB)
Index Storage for 1 Record
Regards
Rah

Estimating DabaBase space growth

Hello! All.
I need to estimate a DataBase space growth, but I 've never had something
like that.
Anybody could help me wiht this?
Which informations a need to make this estimative?
Are there any rules or template to estimate it?
Thanks a lot
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200603/1
Hi
In Books online there is a section on how to estimate the size of a database
under the Creating and Maintaining a database section. As a rougher measure
you could look at the current size and number of entries and just work with
averages. There are a couple of stored procedures on the accompanying discs
with Inside SQL Server 2000 by Kalen Delaney ISBN 0-7356-0998-5 that will
help.
John
"julianohorta via droptable.com" wrote:

> Hello! All.
> I need to estimate a DataBase space growth, but I 've never had something
> like that.
> Anybody could help me wiht this?
> Which informations a need to make this estimative?
> Are there any rules or template to estimate it?
> Thanks a lot
> Juliano Horta
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200603/1
>
|||Hello!
Thank you very much
John Bell wrote:[vbcol=seagreen]
>Hi
>In Books online there is a section on how to estimate the size of a database
>under the Creating and Maintaining a database section. As a rougher measure
>you could look at the current size and number of entries and just work with
>averages. There are a couple of stored procedures on the accompanying discs
>with Inside SQL Server 2000 by Kalen Delaney ISBN 0-7356-0998-5 that will
>help.
>John
>[quoted text clipped - 8 lines]
Message posted via http://www.droptable.com

Estimating DabaBase space growth

Hello! All.
I need to estimate a DataBase space growth, but I 've never had something
like that.
Anybody could help me wiht this?
Which informations a need to make this estimative?
Are there any rules or template to estimate it?
Thanks a lot
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1Hi
In Books online there is a section on how to estimate the size of a database
under the Creating and Maintaining a database section. As a rougher measure
you could look at the current size and number of entries and just work with
averages. There are a couple of stored procedures on the accompanying discs
with Inside SQL Server 2000 by Kalen Delaney ISBN 0-7356-0998-5 that will
help.
John
"julianohorta via droptable.com" wrote:

> Hello! All.
> I need to estimate a DataBase space growth, but I 've never had something
> like that.
> Anybody could help me wiht this?
> Which informations a need to make this estimative?
> Are there any rules or template to estimate it?
> Thanks a lot
> Juliano Horta
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200603/1
>|||Hello!
Thank you very much
John Bell wrote:[vbcol=seagreen]
>Hi
>In Books online there is a section on how to estimate the size of a databas
e
>under the Creating and Maintaining a database section. As a rougher measure
>you could look at the current size and number of entries and just work with
>averages. There are a couple of stored procedures on the accompanying discs
>with Inside SQL Server 2000 by Kalen Delaney ISBN 0-7356-0998-5 that will
>help.
>John
>
>[quoted text clipped - 8 lines]
Message posted via http://www.droptable.com

Estimating DabaBase space growth

Hello! All.
I need to estimate a DataBase space growth, but I 've never had something
like that.
Anybody could help me wiht this?
Which informations a need to make this estimative?
Are there any rules or template to estimate it?
Thanks a lot
Juliano Horta
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1Hi
In Books online there is a section on how to estimate the size of a database
under the Creating and Maintaining a database section. As a rougher measure
you could look at the current size and number of entries and just work with
averages. There are a couple of stored procedures on the accompanying discs
with Inside SQL Server 2000 by Kalen Delaney ISBN 0-7356-0998-5 that will
help.
John
"julianohorta via SQLMonster.com" wrote:
> Hello! All.
> I need to estimate a DataBase space growth, but I 've never had something
> like that.
> Anybody could help me wiht this?
> Which informations a need to make this estimative?
> Are there any rules or template to estimate it?
> Thanks a lot
> Juliano Horta
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1
>|||Hello!
Thank you very much
John Bell wrote:
>Hi
>In Books online there is a section on how to estimate the size of a database
>under the Creating and Maintaining a database section. As a rougher measure
>you could look at the current size and number of entries and just work with
>averages. There are a couple of stored procedures on the accompanying discs
>with Inside SQL Server 2000 by Kalen Delaney ISBN 0-7356-0998-5 that will
>help.
>John
>> Hello! All.
>[quoted text clipped - 8 lines]
>> Juliano Horta
--
Message posted via http://www.sqlmonster.com