Post reply

Database Expansion

  • December 7, 2007 at 12:39 pm

    #122548

    I will have to expand our database soon. I will need to expand it at least 40GB. The current size is 260GB. There is 88GB free on the LUN. The question is how long will it take to expand the database 40GB? Should I do it in 10GB chunks? I would also expect to do it in QA and not EM so it does not timeout. How long will it take to expand a database 40GB?

    Thanks,

  • December 7, 2007 at 1:36 pm

    #758214

    How about setting it to autogrow, with a limit of 300 Gig ?

  • December 8, 2007 at 4:21 am

    #758283

    it should resize instantly, it's a tiny increment. Don't do it in small chunks you'll only increase ntfs fragmentation. I suggest you check for that prior to expanding and maybe after too?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • December 8, 2007 at 10:10 am

    #758301

    Double posting is so rude... waste time answering one only to find answer on the other.

    http://www.sqlservercentral.com/Forums/Topic430841-5-1.aspx

    http://www.sqlservercentral.com/Forums/Topic430840-146-1.aspx

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

  • December 9, 2007 at 2:46 pm

    #758410

    I wouldn't recommend autogrow, you have no control when file expands, resize manually and set it to the size you need. I would recommend scheduling it at an off peak time to avoid any contention.

    Gethyn Elliswww.gethynellis.com

  • December 10, 2007 at 2:39 am

    #758512

    If the service account running SQL Server has the Windows 'perform volume maintenance' right (see Local Security Policy), then SQL can use 'instant file initialisation' (see BOL) and the growth will happen immediately.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • December 10, 2007 at 6:21 am

    #758555

    Sorry about the double posting!

Viewing 7 posts - 1 through 6 (of 6 total)

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