Post reply

The Basics of Sizing a SQL Server Database

  • July 22, 2001 at 12:00 am

    #104504

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

    Brian Knight
    Free SQL Server Training Webinars

  • June 30, 2006 at 4:42 am

    #646924

     

    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

  • June 30, 2006 at 5:52 am

    #646938

    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.

  • June 30, 2006 at 5:59 am

    #646940

    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.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 30, 2006 at 6:46 am

    #646950

    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 ...

  • June 30, 2006 at 8:27 am

    #646987

    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.

  • June 30, 2006 at 9:02 am

    #646995

    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

  • July 7, 2006 at 12:13 pm

    #648051

    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.

  • July 1, 2007 at 11:36 pm

    #716432

    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.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • July 5, 2007 at 12:11 pm

    #717476

    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...

  • July 5, 2007 at 12:13 pm

    #717477

    ...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??? 

  • July 8, 2007 at 11:00 am

    #717878

    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

  • May 22, 2008 at 9:48 am

    #819220

    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!

  • August 1, 2008 at 3:31 am

    #851711

    i could'nt download the storedproc.

    "Keep Trying"

  • August 1, 2008 at 4:06 am

    #851729

    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 40 total)

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