Post reply

Proactive sql dba activities for Production Databases

  • January 16, 2013 at 10:24 pm

    #267114

    Hi,

    Please provide some of Proactive sql dba activities for Production Databases.

  • January 16, 2013 at 10:40 pm

    #1578084

    Index Maintenance

    Backups

    Integrity Checks

    Deadlock monitoring

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 16, 2013 at 11:58 pm

    #1578102

    Monitor blocking

    Monitor free space in the data, log and disks. Increase the DB, Log file size when required to avoid auto-growth

    Alerts for job, log shipping, replication, etc.

    Monitor log file size/growth

    Alerts for high memory, cpu utilization.

  • January 17, 2013 at 3:27 am

    #1578192

    SQLRNNR (1/16/2013)

    Index Maintenance

    Backups

    Integrity Checks

    Deadlock monitoring

    Don't forget to restore those backups.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • January 17, 2013 at 9:30 am

    #1578377

    Sean Pearce (1/17/2013)

    SQLRNNR (1/16/2013)

    Index Maintenance

    Backups

    Integrity Checks

    Deadlock monitoring

    Don't forget to restore those backups.

    Very true

    As the saying goes, you don't have a backup until you have test restored it.:-D

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 17, 2013 at 9:44 am

    #1578388

    Wait analysis

    Performance benchmarking

    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

  • January 17, 2013 at 10:04 am

    #1578399

    monitor erorlogs

    monitor sqlagent jobs

    ensure your backups are actually happening (dont just monitor for failure)

    test your DR procedures from time to time

    ---------------------------------------------------------------------

  • January 17, 2013 at 10:09 am

    #1578403

    Establish and Enforce standards

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 18, 2013 at 2:14 am

    #1578597

    Thanks to all

Viewing 9 posts - 1 through 8 (of 8 total)

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