The Basics of Sizing a SQL Server Database

  • Brian Knight

    One Orange Chip

    Points: 27249

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bknight/sizingadatabase.asp

  • EugeneZ-162636

    Default port

    Points: 1448

     

    Nice try Brian,

    But there is not much new ideas and info except advertisement of the Datatect 1.6 (BTW - good tool)

    For example - Ok you calculated with Erwin or without a size of database->

    Can you tell now how big HDD to buy? How big trans log files can be after reindex? Anything about recovery model in view of the Trans log file? and maintenances? what about statistics (size consuming too)...

    Best regards,

    EugeneZ

  • Mike Metcalf

    SSCrazy Eights

    Points: 8763

    I thought that it was a decent article, and one very close to my heart as  our DB is currently 1.6TB and growing by 15-30 GB each and every week.

  • Jeff Moden

    SSC Guru

    Points: 993788

    I agree... a decent article... but it DOES sound like an advertisement and provides no real info as to how to do the sizing estimate if you don't have those tools.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems

  • Georges Belhadjali

    Newbie

    Points: 9

    Agree too, sounds interesting regarding Erwin, the same feature exist in Power AMC (Pub!), nevertheless I would have appreciate more info about how to size the transaction log ...

  • Brian Munier

    SSCrazy

    Points: 2765

    Not much content.

    ERwin WAS a great product, BUT Computer Associates (CA) as is their business model, has not released even bug fixes since they acquired the product.  They have done new databases, but that's it.

    If you have it, use it.  If not buy something else.

    If you want to buy the rights from them and revitalize development of the tool, lots of people would love it.

  • DavidSimpson

    Hall of Fame

    Points: 3539

    Not promoting one tool over another but CA has done quite a bit for Erwin.  They even had a big focus on bug improvments to the point of holding off any improvements... I believe it was around release 4.14.  This made a big difference on bugs with RE and complete compares.  I'm not on the current release so I cannot make comments on it now.

    As for the article, good article for a starting point on sizing issues with a database... as the title indicates.  I think the tools mentioned give some basic direction on where to go for further 3rd party help.  Listing out additional resources would have helped keep it from sounding a bit like an advertisement but it makes sense that you would focus on the ones you are familiar with.

    Any plans for more indepth articles on the subject?

    ds

  • Brian Munier

    SSCrazy

    Points: 2765

    Well, If you say so, it must be recent development however.  In Dec 2004 they were still on Version 3 which was the same as it had been 2 or 3 years before.

    I met another DBA who worked for a company that got bought out by CA and after 3 or 4 years, they hadn't done any bug fixes.

    I hope they do support it and improve it.

  • Jeff Moden

    SSC Guru

    Points: 993788

    Sorry for being a year late.

    I thought the title of this article was "Sizing a Database"... not an advertisement for some 3rd party software.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems

  • d-458788

    SSC Rookie

    Points: 34

    errr...ah...Where's the Beef? 

    Reads like someone spent too much time playing video games and hurridly tossed the article together to meet a deadline...

  • d-458788

    SSC Rookie

    Points: 34

    ...and why did this thing show up in my inbox today as if it was a fresh article???  You mean to tell me that given a full year, they had to recycle the SAME non-article??? 

  • CyclingRabbit

    Say Hey Kid

    Points: 673

    I have a question regarding the script provided at

    http://www.sqlservercentral.com/columnists/bknight/usp_databases.txt

    How is this different from running the sp_helpdb procedure which, among other things, returns the sizes of all the databases?

    Thanks.

    Alin

  • dbrodine

    Grasshopper

    Points: 21

    You might be interested in "Mathematical Server Sizing" software, freely available on SourceForge. Here's a link.

    http://sourceforge.net/search/?type_of_search=soft&type_of_search=soft&words=mathematical+server+sizing

    Be sure and check out the documentation with this project. It describes some sample sizings. For a formal description of the math involved, see IEEE "Computer", July 2006 issue.

    Good luck!

  • ChiragNS

    One Orange Chip

    Points: 26137

    i could'nt download the storedproc.

    "Keep Trying"

  • SuperDBA-207096

    SSCrazy Eights

    Points: 8176

    I couldn't find the sproc either...

    Article was high-level, and give a real-world view (easier to use the tools than try and tackle it manually). Thought it was good- maybe could have a bit more meat about sizing db's or some general advice (try to make them big enough to start so they dont expand when you're not expecting it etc.)

Viewing 15 posts - 1 through 15 (of 41 total)

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