May 18, 2016 at 5:59 pm
Hi
I am planning to CREATE A NEW 2014 DB.
For last 30 years, I have less than million records in a table and may end up having 10 to 20 tables including LOOKUP, so what should be my DB Size ? Keep in mind that DB will grow and HISTORICAL Record retention policy is FOREVER.
May 18, 2016 at 11:09 pm
Hi,
I think it's impossible to guess the right size of your database.
Please post your table design, maybe someone can calculate the right size for 30 million rows.
What about index ore something else which need space also?
Kind regards,
Andreas
May 19, 2016 at 5:56 am
Each table may have 15 columns. ...
give me a ball park, I can afford any reasonable server
May 19, 2016 at 6:05 am
kruezer had it right; without data and substantially more information, it's just a guess.
if i said 700 gig is required, and kruezer said 80 gig , who has the better guess?
the database will make itself larger as needed, so you just need to make sure that your hardware will support the disk space you need for backups, additional side by side stores for testing, etc.
your database retention policy is important there too.
in my shop, a "standard" virtual for SQL developmentgets created with an 80 gig C:\ drive and 200 Gig D:\ drive for data.
more drives or space gets added as needed.(ie L\ for logs, T:\ for temp etc)
Lowell
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply