Re: how to decide about the database size
From: Mark Allison (marka_at_no.tinned.meat.mvps.org)
Date: 12/07/04
- Next message: Hugo Kornelis: "Re: Index tree"
- Previous message: Hielien: "BCP and keyword column names"
- In reply to: bala: "how to decide about the database size"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 07 Dec 2004 10:02:50 +0000
bala,
You need to find out the width in bytes of all your tables. Estimate how
much data will go in those tables. It becomes difficult with many
varchar columns. Some articles below might help you. It will become easy
if you already have some data and have some idea of growth over the
short term by logging database size over time. You could create a
SQLAgent job to log this, or use a third party enterprise monitoring tool.
You then just extrapolate the data to get a rough idea how it might
grow. Note, the data does not always grow in a linear fashion, it could
have growth spurts, or be exponential or logathithmic.
Quite old but nevertheless useful:
SQL Server 7.0 Storage Engine Capacity Planning Tips
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/storageeng.asp
I haven't read this but it looks reasonable at first glance;
PERFORMANCE MANAGEMENT AND CAPACITY PLANNING FOR MICROSOFT SQL SERVER
http://www.metron.co.uk/reference/technical/documents/tech18.pdf
SQL Server Performance website
http://www.sql-server-performance.com
-- Mark Allison, SQL Server MVP http://www.markallison.co.uk Looking for a SQL Server replication book? http://www.nwsu.com/0974973602m.html bala wrote: > hi > I want some help regarding deciding the database size > how to decide the database file size > your sugessions are welcome > > regards > bala > >
- Next message: Hugo Kornelis: "Re: Index tree"
- Previous message: Hielien: "BCP and keyword column names"
- In reply to: bala: "how to decide about the database size"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
