Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning the Size of DB became very big , any idea to cut it to smaller RE: the Size of DB became very big , any idea to cut it to smaller

  • March 22, 2015 at 8:43 pm

    #1785602

    Jeff Moden (3/21/2015)

    wagdy_maher (3/21/2015)

    its DB for online system ,I can take it down for one hour in the week end

    it's normal single server no HA till now

    Data size 300 GB

    storage capcity : over san storage , no problem about storage

    Is that for a single table? If so, how many months are in that 300GB now?

    Understood but I'm trying to get to the root of several problems that I'm fairly sure that are starting for you. What size are the largest 3 tables (including any blobs and indexes) and what is their purpose? Are they audit tables, tables like an InvoiceDetail table might be, or ???

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