Post reply

Dtabase growth forecasting tasks for dba

  • February 2, 2010 at 12:13 am

    #94423

    Hi,

    As of now my sql database is 2gb, daily growth increasing as a dba what are all the task need to create in maintenance plans for database performence like DBCC command rebuilding indexes etc....

    can u please suggest some more task for the production server live database we r using sql server

    8.00.2039SP4Personal Edition

    please sugest

    Thanks in advance

  • February 2, 2010 at 4:27 pm

    #1112567

    What kind of window for off-peak usage hours do you have? I would suggest scheduling jobs during off-peak hours to complete the following:

    - rebuild all indexes (since your database is only 2GB; this may need to be modified as the maint plan takes longer to accomplish)

    - check database integrity, backup the database

    Joie Andrew
    "Since 1982"

  • February 3, 2010 at 4:28 pm

    #1113328

    The topic title suggests you want to know about forecasting database growth, but the content is that you want to know which maintenance to apply.

    Do you want to know about growth forecasting?

  • March 22, 2010 at 4:07 am

    #1137475

    yes ineed to do this Do you want to know about growth forecasting?

    as well with regular dba task to increase the performence of the DB

    monthly my db grows ~1gb

    thanks in advance

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

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