SQL Server Performance Forum – Threads Archive
DB Sizing?Hello All, I have a table that contain currently contain 284,722 records using the diskspace of 141784 Kb, I am trying to estimate the amount of space i would required if the number of records increase to 600,000 or 700,000. Also it will be great if someone can point to a tool that helps is estimating the DB Sizing. Regards,
About tool I don’t know.
But, is not so easy to know what will be the DB size in the future.
It deppendns on many factors like: Moder Recovery, Maintenance plan, indexes, etc. BTW, are lack of space? Luis Martin
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
No not a lack of space but better to know before i buy a new hardware.
Based on row length you can do some calculation. Going forward you can keep track of no of rows increment each month. I guess this is just basic approach for simple approximation, and as Luis mentioned other things come into picture like indexing/fragmentation etc.
Hi,<br /><br />still its approx figure based on all calulations because indexing/defragmentation + volume of DML(s) will not remain same all the days but as general approach may use sp_spaceused weekly to monitor growth of tables .<br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
True, SP_SPACEUSED is the first and best to look for the sizes. Refer these articles for your information: http://www.databasejournal.com/features/mssql/article.php/3339681
http://vyaskn.tripod.com/track_sql_database_file_growth.htm Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.