Post reply

DBA task for large production database

  • October 7, 2012 at 11:28 pm

    #269028

    Hi,

    My production DB size is now 50Gb its increasing (sqlserver 2008 R2 Enterprice edition)

    Let me know the DBA task to be done for large database like Integrity check ,fragementation free & performance point .

    Thanks in advance

  • October 8, 2012 at 2:32 am

    #1546600

    Check the following factors are considered or not?

    1.Database size and growth should be mentioned initially.

    2.Check the unused index and drop the unused index.

    Then set up your maintenance plan for backup,dbcc reindex,etc

    Regards,
    Kumar

  • October 8, 2012 at 3:45 am

    #1546622

    50GB is not large. You should be able to handle it just like any other smaller DB.

    Integrity check is a must for all DBs whether small or large.

  • October 8, 2012 at 4:34 am

    #1546633

    Thanks for the reply

    I added Integrity check before backup task in the Maintenance plan

    But Job/MP is failing as per the scheduled

  • October 8, 2012 at 5:17 am

    #1546645

    With what error? Just saying it's failing isn't much use.

    Maintenance:

    Backups, full maybe diff, probably log depending on RPO and RTO requirements

    Index maintenance

    Integrity checks

    Possible additional statistics maintenance

    Test restores to ensure your backups are useful.

    Alerts configured to tell you before things break

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 8, 2012 at 12:48 pm

    #1546884

    First, before I do anything on a new server I stand up a pre-determined utility database for DBA related activities. Maintenance jobs that I run but not limiting to are:

    Clearing out aged backups

    Creating backups for new databases that get dropped onto my server ( in my case all DB's are mission critical )

    Cycle SQL Server Error Logs

    Index Defrag

    Smart Re-Indexing

    Alerting on Extended Blocking

    Again, these are my main chunks for maintenance but definitely not limiting what I have listed. You could have more, 50GB is not really that big. Should be able to get a good grasp on it.

    Thanks,

    Chris

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

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