Predict database size

Calculate database size for feasibility study

Page 1 of 1

1 Replies - 4095 Views - Last Post: 26 July 2008 - 05:54 PM Rate Topic: -----

#1 porcupine75   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 03-September 07

Predict database size

Posted 26 July 2008 - 05:43 PM

Hello Guys!

I have done not this thing before but I think this would be useful for feasibility studies.
Dependent or not on database software, how can one calculate (for tell) a disk space required for a certain/huge amount of records for one's database.
Here's a sample single table design:
Transactions Table
TransactionCounter AutoIncrement Long
TransactionId Number Long
TransactionDate Date/Time
StockCode Number Long
Quantity Number Short
Sub-Total Number Short
Remarks String * 30
Posted Boolean

Thanks! :rolleyes:

This post has been edited by porcupine75: 26 July 2008 - 05:45 PM

Is This A Good Question/Topic? 0
  • +

Replies To: Predict database size

#2 Martyr2   User is offline

  • Programming Theoretician
  • member icon

Reputation: 5241
  • View blog
  • Posts: 14,037
  • Joined: 18-April 07

Re: Predict database size

Posted 26 July 2008 - 05:54 PM

Well your estimation is going to greatly depend on the database type you use. Just because databases store data differently and some are more sloppy than others.

However one great article you can check out refers to how you can estimate the size of a database based on its tables, clustered/non clustered indexes, and heap.

Estimating the Size of a Database - SQL Server - MSDN

The factors can be applied to many other databases. By knowing the size of indexes, calculating the overall storage size of tables based on the length of fields * number of rows, and calculating the heap you can get a good approximation.

That would be a great place to start the search. :)
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1