question

user-806 avatar image
user-806 asked

Estimate New database Size

Hi, I am going to estimate a new database size which dont have any row right now & having database structure.I have found one article in MSDN( http://technet.microsoft.com/en-us/library/ms187445.aspx) to estimate database size which says I have to calculate all the table size & Index size. Want to know is there any tool or excel which will genareate the estimation based on the msdn logic. I have found one article but that link is not opening if you have any other please let me know. http://sqlserverdiaries.com/blog/index.php/2011/05/estimating-the-size-of-an-sql-server-database/
sizing
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
I am not aware of any tools that do this. In general, taking the data size, index size, and the estimated number of rows is how most people arrive at an estimated database size.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.