estimating tempdb usage

Is there any way to estimate how much space will be needed by tempdb?
I have a user executing a simple query similar to:
select orders.customerid, sum(quantity*unitprice) as amount
from orders inner join [order details]
on orders.orderid=[order details].orderid
group by orders.customerid
In other words, two thin (not too many columns) tables, equi-join,
summarizing and a group by. The only trouble is her two tables have
28000 rows and nearly 800 million rows. Her query dies after a few
hours when tempdb autogrows and runs out of disk space at 17 gig. I
know tempdb is used for work tables, joins, sorts, group bys, etc.
But knowing the columns sizes and number of rows, is there a way to
estimate how much tempdb will be needed? She's basically the only
user on the system.
By the way, this is SQL Server 2000.
Thanks,
ScottI guess it would be better to Grow the tempdb first, then run oyur query.
I had the same problem on SQL Server 6.5 to 2000 migration with the log
files (we had big tables as well) , the Autogrowth didn´t work. So we had to
create the database and transaction logs big enough to support migration
process before initiate it.
HTH
"scott parmelee" <s_parmelee@.hotmail.com> escreveu na mensagem
news:e14a8116.0311130819.725c0a4@.posting.google.com...
> Is there any way to estimate how much space will be needed by tempdb?
> I have a user executing a simple query similar to:
> select orders.customerid, sum(quantity*unitprice) as amount
> from orders inner join [order details]
> on orders.orderid=[order details].orderid
> group by orders.customerid
> In other words, two thin (not too many columns) tables, equi-join,
> summarizing and a group by. The only trouble is her two tables have
> 28000 rows and nearly 800 million rows. Her query dies after a few
> hours when tempdb autogrows and runs out of disk space at 17 gig. I
> know tempdb is used for work tables, joins, sorts, group bys, etc.
> But knowing the columns sizes and number of rows, is there a way to
> estimate how much tempdb will be needed? She's basically the only
> user on the system.
> By the way, this is SQL Server 2000.
> Thanks,
> Scott

Estimating Table Sizes

Is it possible to write a query that can estimate the space a table is
using in the database? I would like to be able to generate a report
that can display the amount of disk space a table is consuming.How about using sp_spaceused?
RLF
<marcusq71@.gmail.com> wrote in message
news:1173901596.189278.188470@.l75g2000hse.googlegroups.com...
> Is it possible to write a query that can estimate the space a table is
> using in the database? I would like to be able to generate a report
> that can display the amount of disk space a table is consuming.
>|||Hello,
Go to the specific database and execute the below command to get the space
usage for all tables individually.
EXEC sp_MSForEachTable 'EXEC sp_spaceused [?]';
Thanks
Hari
<marcusq71@.gmail.com> wrote in message
news:1173901596.189278.188470@.l75g2000hse.googlegroups.com...
> Is it possible to write a query that can estimate the space a table is
> using in the database? I would like to be able to generate a report
> that can display the amount of disk space a table is consuming.
>|||On Mar 15, 12:46 am, "marcus...@.gmail.com" <marcus...@.gmail.com>
wrote:
> Is it possible to write a query that can estimate the space a table is
> using in the database? I would like to be able to generate a report
> that can display the amount of disk space a table is consuming.
Make sure you run DBCC UPDATEUSAGE on the database before you run
sp_spaceused
Reports and corrects inaccuracies in the sysindexes table, which may
result in incorrect space usage reports by the sp_spaceused system
stored procedure.
M A Srinivas|||On Mar 15, 2:07 am, "M A Srinivas" <masri...@.gmail.com> wrote:
> On Mar 15, 12:46 am, "marcus...@.gmail.com" <marcus...@.gmail.com>
> wrote:
>
> Make sure you run DBCC UPDATEUSAGE on the database before you run
> sp_spaceused
> Reports and corrects inaccuracies in the sysindexes table, which may
> result in incorrect space usage reports by the sp_spaceused system
> stored procedure.
> M A Srin
Thank you all for these suggestions. This is exactly what I am
looking for. I was not clear on my initial request but the
MSforeachtable stored procedure was exactly what I was looking for.

Estimating Table Sizes

Is it possible to write a query that can estimate the space a table is
using in the database? I would like to be able to generate a report
that can display the amount of disk space a table is consuming.
How about using sp_spaceused?
RLF
<marcusq71@.gmail.com> wrote in message
news:1173901596.189278.188470@.l75g2000hse.googlegr oups.com...
> Is it possible to write a query that can estimate the space a table is
> using in the database? I would like to be able to generate a report
> that can display the amount of disk space a table is consuming.
>
|||Hello,
Go to the specific database and execute the below command to get the space
usage for all tables individually.
EXEC sp_MSForEachTable 'EXEC sp_spaceused [?]';
Thanks
Hari
<marcusq71@.gmail.com> wrote in message
news:1173901596.189278.188470@.l75g2000hse.googlegr oups.com...
> Is it possible to write a query that can estimate the space a table is
> using in the database? I would like to be able to generate a report
> that can display the amount of disk space a table is consuming.
>
|||On Mar 15, 12:46 am, "marcus...@.gmail.com" <marcus...@.gmail.com>
wrote:
> Is it possible to write a query that can estimate the space a table is
> using in the database? I would like to be able to generate a report
> that can display the amount of disk space a table is consuming.
Make sure you run DBCC UPDATEUSAGE on the database before you run
sp_spaceused
Reports and corrects inaccuracies in the sysindexes table, which may
result in incorrect space usage reports by the sp_spaceused system
stored procedure.
M A Srinivas
|||On Mar 15, 2:07 am, "M A Srinivas" <masri...@.gmail.com> wrote:
> On Mar 15, 12:46 am, "marcus...@.gmail.com" <marcus...@.gmail.com>
> wrote:
>
> Make sure you run DBCC UPDATEUSAGE on the database before you run
> sp_spaceused
> Reports and corrects inaccuracies in the sysindexes table, which may
> result in incorrect space usage reports by the sp_spaceused system
> stored procedure.
> M A Srin
Thank you all for these suggestions. This is exactly what I am
looking for. I was not clear on my initial request but the
MSforeachtable stored procedure was exactly what I was looking for.
sql

Estimating Table Sizes

Is it possible to write a query that can estimate the space a table is
using in the database? I would like to be able to generate a report
that can display the amount of disk space a table is consuming.How about using sp_spaceused?
RLF
<marcusq71@.gmail.com> wrote in message
news:1173901596.189278.188470@.l75g2000hse.googlegroups.com...
> Is it possible to write a query that can estimate the space a table is
> using in the database? I would like to be able to generate a report
> that can display the amount of disk space a table is consuming.
>|||Hello,
Go to the specific database and execute the below command to get the space
usage for all tables individually.
EXEC sp_MSForEachTable 'EXEC sp_spaceused [?]';
Thanks
Hari
<marcusq71@.gmail.com> wrote in message
news:1173901596.189278.188470@.l75g2000hse.googlegroups.com...
> Is it possible to write a query that can estimate the space a table is
> using in the database? I would like to be able to generate a report
> that can display the amount of disk space a table is consuming.
>|||On Mar 15, 12:46 am, "marcus...@.gmail.com" <marcus...@.gmail.com>
wrote:
> Is it possible to write a query that can estimate the space a table is
> using in the database? I would like to be able to generate a report
> that can display the amount of disk space a table is consuming.
Make sure you run DBCC UPDATEUSAGE on the database before you run
sp_spaceused
Reports and corrects inaccuracies in the sysindexes table, which may
result in incorrect space usage reports by the sp_spaceused system
stored procedure.
M A Srinivas|||On Mar 15, 2:07 am, "M A Srinivas" <masri...@.gmail.com> wrote:
> On Mar 15, 12:46 am, "marcus...@.gmail.com" <marcus...@.gmail.com>
> wrote:
> > Is it possible to write a query that can estimate the space a table is
> > using in the database? I would like to be able to generate a report
> > that can display the amount of disk space a table is consuming.
> Make sure you run DBCC UPDATEUSAGE on the database before you run
> sp_spaceused
> Reports and corrects inaccuracies in the sysindexes table, which may
> result in incorrect space usage reports by the sp_spaceused system
> stored procedure.
> M A Srin
Thank you all for these suggestions. This is exactly what I am
looking for. I was not clear on my initial request but the
MSforeachtable stored procedure was exactly what I was looking for.

Estimating Disk Space

Thanks for your replies Tibor / John.
Is there any script/tool available to estimate the size of
the target database. I have the table structures and
estimated rows.
Thanks,
HariI believe that the book "Inside SQL Server 2000" from MS Press comes with such a tool. The book is a
"must" IMO for any intermediate/advanced SQL Server person anyhow, IMO... :-)
--
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:2429f01c45f3c$1f2b89c0$a401280a@.phx.gbl...
> Thanks for your replies Tibor / John.
> Is there any script/tool available to estimate the size of
> the target database. I have the table structures and
> estimated rows.
> Thanks,
> Harisql

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

estimate table spaces

hi guys,
sp_spaceused 'table1'
I have two ntext columns in 'table1',
by default, is sp_spaceused calculating space for ntext too?Hi Britney
All columns are included. You can see this for yourself:
use pubs
go
select * into newtitles from titles
go
exec sp_spaceused newtitles, @.updateusage= true
go
alter table newtitles add info ntext
go
update newtitles set info = replicate(title, 100)
go
exec sp_spaceused newtitles, @.updateusage= true
go
HTH
Kalen Delaney
"Britney" <britneychen_2001@.yahoo.com> wrote in message
news:emryCsOpFHA.1044@.tk2msftngp13.phx.gbl...
> hi guys,
>
> sp_spaceused 'table1'
> I have two ntext columns in 'table1',
> by default, is sp_spaceused calculating space for ntext too?
>
>|||When NTEXT column is NULL, how come it still takes some spaces?
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:ODCxkYQpFHA.3828@.TK2MSFTNGP12.phx.gbl...
> Hi Britney
> All columns are included. You can see this for yourself:
> use pubs
> go
> select * into newtitles from titles
> go
> exec sp_spaceused newtitles, @.updateusage= true
> go
> alter table newtitles add info ntext
> go
> update newtitles set info = replicate(title, 100)
> go
> exec sp_spaceused newtitles, @.updateusage= true
> go
> HTH
> Kalen Delaney
>
> "Britney" <britneychen_2001@.yahoo.com> wrote in message
> news:emryCsOpFHA.1044@.tk2msftngp13.phx.gbl...
>
>|||Kevin
LOB data (type text, ntext and image) is by default stored on separate pages
outside the data rows. As soon as you update any rows with LOB data to
anything, even null, SQL Server will allocate at least 2 additional pages to
start keeping track of that data.
FYI, for ANY fixed length data column, NULLs will take space. So a char(100)
that contains NULL will take the full 100 bytes.
HTH
Kalen Delaney
www.solidqualitylearning.com
"kevin" <pearl_77@.hotmail.com> wrote in message
news:%23OP4VFYpFHA.3380@.TK2MSFTNGP12.phx.gbl...
> When NTEXT column is NULL, how come it still takes some spaces?
>
>
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:ODCxkYQpFHA.3828@.TK2MSFTNGP12.phx.gbl...
>
>

Estimate Log Space for Alter Table Statement

My client's website database is hosted by a third party. I need to alter one of the column definitions for the largest table in the database. Unfortunately, the transaction log fills up if I try to alter the table. I've done all the usual stuff like truncating the log, etc., but the simple fact is that the operation requires more log space than we have available. Therefore, we need to purchase additional disk space for the database.

What I'm looking for is a way to roughly estimate how much log space will be required to alter this table so that we purchase enough but not too much additional space. The table has an identity primary key and 4 other single column indexes: one int, one datetime and two varchar(30) columns.

Any suggestions? Thanks in advance.

You can change the truncate log setting in a database if you don't need it to recover in time of emergency it is a very complicated subject so run a search for truncate log on checkpoint option for your database setting in the BOL(books online). The links below are basic guidelines from Microsoft. Hope this helps.

http://support.microsoft.com/kb/873235

http://msdn2.microsoft.com/en-us/library/aa933068(SQL.80).aspx

|||

If I remember correctly when you alter column in table, SQL server renames old one, created new table with new structure and next moves data into new table. So in your case you need at least amount of space your data table takes for log because all process has to be done at one shot.
But maybe you can do it yourself: create table with new structure and move data from old table to new table with quantity like 100 or 1000 records in one shot? Log file will be small and you should succeed. You only have to take care about identity insert if you have one in your table.

Thanks

|||

Thanks jpazgier, that's a great suggestion! I usually do the alter using Enterprise Manager directly for this client but I have scripted this type of change for other clients. I never thought about taking the generated script and breaking up the insert part of it into multiple inserts and performing the truncate log after each insert. That would reduce the log space required.

If I don't delete the old records as I go, I still need twice the data just for the old and new copies but I wouldn't need so much log space. If I trust my alterations, then I could delete the old records as they get moved into the new copy and really reduce the free space required. Not as safe but probably sufficient.

Thanks

|||

(1) You could keep the DB in simple mode while you do the data transfer.

(2) You can also have a job running to truncate the log during the transfer and let the job run every 1 minute, so you dont have to do it yourself manually.

(3) You can use bcp/Bulk Insert to transfer the data.

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
>
>.
>

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,
HariThese 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...
> > 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
>|||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
>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...
>> > 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
>>
>
>.
>sql

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,
HariThese objects basically don't use any space. Well, the do use a row per obje
ct in sysobjects, a row
per parameter in syscolumns and a row per object in syscomments. The last on
e 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
>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[vbcol=seagreen]
>
>.
>