Post reply

Production DBA Begineer's Task list ?

  • June 28, 2010 at 2:22 am

    #222680

    What kind of TASK or Job a Begginer's Production DBA should be ?

    can anybody list some professional way the job or task assigned to

    Production DBA begineers ?

  • June 28, 2010 at 9:06 am

    #1185833

    1- Check backup status/logs - ensure all databases are recoverable.

    2- Check space at both database and disk levels - ensure system has enough space.

    3- Check SQL Server logs - research and report error messages

    4- Check I/O and CPU at host level

    5- Don't stop asking questions to Senior DBAs.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • June 28, 2010 at 4:15 pm

    #1186101

    diva.mayas (6/28/2010)

    What kind of TASK or Job a Begginer's Production DBA should be ?

    can anybody list some professional way the job or task assigned to

    Production DBA begineers ?

    Everything the Production DBA does but with (sometimes MUCH) more supervision and less pay. And Paul is correct... don't ever stop asking questions of the Senior DBA's.

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

  • June 29, 2010 at 1:18 am

    #1186184

    We have set up monitoring jobs, which will monitor

    ?Log , data and disk space and send alerts if it reaches a thershold.

    ?A regular full backup with log shipping.

    ?Job to send alert if it reads any error in SQL server logs.

    ?Auditing logins

    ?SQL Server perf report, CPU, IO & mem utilization etc

    You will find lots of info in this forum.

    "More Green More Oxygen !! Plant a tree today"

  • June 29, 2010 at 5:43 am

    #1186286

    Make sure that your database is secured

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

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