Do you wanna know the size of an existing db? You can run the following command:
André César Rodrigues
Please click the Mark as answer button and vote as helpful if this reply solves your problem. Thanks!Blog: http://sqlmagu.blogspot.com.br LinkedIn:
Look at the tables that will become the biggest in size, take a sample and increment this by the expected growth.
It does depend on the row size and amount of indexes, so you need a sample to go from there.
when you create new database it tooks the copy of model database. your model database size will be approx. size of your new database. After creation the amount of data you are going to insert will determine the size.
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.
- Proposed as answer by Allen Li - MSFTMicrosoft contingent staff, Moderator Wednesday, October 02, 2013 7:34 AM
- Unproposed as answer by pscorca Wednesday, October 02, 2013 9:10 AM
You could use the "Data generation" feature of Visual Studio to assist in creating data.
other than that, if the developer hasn't prepared an Excel sheet with some calculations there is no way out of the blue other than "rapid" guessing.
Ok, but does it exist a rapid manner (with a tool) to estimate the size without creating the db?
Estimate the size of the data itself and double it for basic table sizes.
Indexing is harder to estimate and can take significant space, but I'd say double it again.
So, about 4x the size of the raw data for an OLTP database, I'd say will get you a *rough* estimate.
Then of course you need space for logs, space for tempdb, space for backups, and space for ETL files.
Luckily disk space is cheap, though when you put it on a first-class SAN, and then duplicate the whole thing for dev, fix, QA, UAT, DR, and HA ... maybe not so cheap!