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,Nitin
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
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>