Post reply

Estimating space needed for database

  • May 28, 2013 at 6:21 am

    #275524

    Hello - is there a way to determine the disk space needed based on this request...

    "please determine if we could host a data mart in SQL Server that would consist of a minimum of two tables (perhaps more) with the largest table consisting of 200 columns and ten million rows with a record size of about 1500 bytes"

    Thanks in advance

    Dave

  • May 28, 2013 at 6:30 am

    #1618925

    assuming the second table could potentially be the same size as the max for the first, it looks like a 30 gig database to me for just the data?

    1.5Meg * 10 Million * 2 tables

    select 1.5 * 10000000.0 * 2.0 As MegaBytes

    i'd add another 50% for indexing, and maybe another 50% for growth, so i'd try to allot 60 gig of space?

    Maybe some other peers will have some better numbers for you.

    the 1500 bytes per row sounds a little low for me; 200 columns, if they were all integers would be at least 1600 bytes, and a typical datamart is going to have descriptions in it, so the per-row size estimate seems light to me.

    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!

  • May 28, 2013 at 6:42 am

    #1618929

    It isn't much to go on, but the words "perhaps more" are a little vague. This might mean more data tables; it might mean lookup tables with key/description pairs. It really depends on the type of data you're going to store. Storing 150 bits it a lot different than storing 150 nvarchar(255) fields.

    This will be made more painful if your data is on a local drive and not on a SAN volume. In a SAN, the SAN administrator can typically allocate more space if you need it, but he has to have the space to allocate.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • May 28, 2013 at 7:05 am

    #1618937

    Thank you - both of these answers were very helpful.

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

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