Tuesday, March 27, 2012

Estimate disk space required for my DB

Hi All,
I got some hints on estimating the table size from BOL.
But how do I estimate other objects like SP, UDF etc.
I want to estimate the disk size required at my deployment
SQL Server box.
Is there any tool available to estimate the DB size?
Thanks in advance,
Hari
These objects basically don't use any space. Well, the do use a row per object in sysobjects, a row
per parameter in syscolumns and a row per object in syscomments. The last one will contain the
actual source code for the object. I wouldn't worry about these things...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hari Shankar" <anonymous@.discussions.microsoft.com> wrote in message
news:23b5101c45f37$15b43c70$a601280a@.phx.gbl...
> Hi All,
> I got some hints on estimating the table size from BOL.
> But how do I estimate other objects like SP, UDF etc.
> I want to estimate the disk size required at my deployment
> SQL Server box.
> Is there any tool available to estimate the DB size?
> Thanks in advance,
> Hari
|||Hi
The biggest size will always be the data, stored procedures and function
definitions are mainly held in the syscomments tables. It should be pretty
static therefore once you have loaded them into the database it will not
change.
John
"Hari Shankar" <anonymous@.discussions.microsoft.com> wrote in message
news:23b5101c45f37$15b43c70$a601280a@.phx.gbl...
> Hi All,
> I got some hints on estimating the table size from BOL.
> But how do I estimate other objects like SP, UDF etc.
> I want to estimate the disk size required at my deployment
> SQL Server box.
> Is there any tool available to estimate the DB size?
> Thanks in advance,
> Hari
|||Hi,
Add on to Tiber,
Is there any tool available to estimate the DB size?
No tool can suggest you the actual hard disk requirement.
There is no easy way to estimate precisely the storage requirements for a
given database.
If an accurate size estimate is needed, it is suggested that a test database
is setup in a test server with
suitable fields, numbers of tables and queries. It should be filled with
suitable random data
and operated as a database for a short time before attempting to measure the
disk storage needed
to store and manage all the information.
If you have an existing system you can calculate the hard disk requirement
based on that.
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OWbFFozXEHA.712@.TK2MSFTNGP11.phx.gbl...
> These objects basically don't use any space. Well, the do use a row per
object in sysobjects, a row
> per parameter in syscolumns and a row per object in syscomments. The last
one will contain the
> actual source code for the object. I wouldn't worry about these things...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Hari Shankar" <anonymous@.discussions.microsoft.com> wrote in message
> news:23b5101c45f37$15b43c70$a601280a@.phx.gbl...
>
|||Thanks Hari for your reply.
I fully agree with you. But I'm looking for a tool/script
which will implement the table estimate calculation (as in
BOL). Instead of applying those calculation manually for
each table, a script/tool may help me.
What is the standard approach for disk sizing for an
application?
Thanks a lot.
Hari
>--Original Message--
>Hi,
>Add on to Tiber,
>Is there any tool available to estimate the DB size?
>No tool can suggest you the actual hard disk requirement.
>There is no easy way to estimate precisely the storage
requirements for a
>given database.
>If an accurate size estimate is needed, it is suggested
that a test database
>is setup in a test server with
>suitable fields, numbers of tables and queries. It should
be filled with
>suitable random data
>and operated as a database for a short time before
attempting to measure the
>disk storage needed
>to store and manage all the information.
>If you have an existing system you can calculate the hard
disk requirement
>based on that.
>--
>Thanks
>Hari
>MCDBA
>"Tibor Karaszi"
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in[vbcol=seagreen]
>message news:OWbFFozXEHA.712@.TK2MSFTNGP11.phx.gbl...
do use a row per[vbcol=seagreen]
>object in sysobjects, a row
syscomments. The last[vbcol=seagreen]
>one will contain the
about these things...[vbcol=seagreen]
wrote in message[vbcol=seagreen]
BOL.[vbcol=seagreen]
deployment
>
>.
>

No comments:

Post a Comment