Post reply

2014 DB size estimation

  • May 18, 2016 at 5:59 pm

    #326380

    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

    #1880086

    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

    #1880147

    Each table may have 15 columns. ...

    give me a ball park, I can afford any reasonable server

  • May 19, 2016 at 6:05 am

    #1880149

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply