Importance of DAILY CHECK LIST! | SansSQL

Friday, November 1, 2013

Importance of DAILY CHECK LIST!

Here I am, back from long holidays to my blogs! I was thinking of writing in which happens to be part of any DBA on production support (it can different levels as such).  So, have chosen to blog the importance of Daily Check list.

Daily check list:

The following is purely what we have adopted as part of the routine daily check. The check can be done at one time everyday and at a convenient time so that we don't miss anything.

First thing, we have selected list of servers which are very critical for the business and have to be part of check list.

Secondly, the above doesn't mean that alerts are not configured; :)The servers have been configured with all the necessary alerts flow.

And finally, the servers are part of daily check list which helps in identifying any kind of errors and work proactively to avoid any outages that may follow.

Ok, now we have the list of servers, What all to check? How do we start?

Let me answer each of the above questions posed -

What all to be part of Daily checklist -
  • Routine Jobs\Job steps failures
  • Maintenance Plans\Jobs
  • SQL logs and Agent logs
  • NT logs (application and System)
  • Replication Monitor (if configured)
  • Log shipping Monitor (if configured)
  • Database Mirroring (if configured)
  • Any other DR or HA solutions which you have configured 
  • Space Issues (from collective Report)
  • Additional check like "Agent Mail" check from servers, Services etc

How do we start?
First, make sure to read "ALL" mails with respect to project. This makes it easier to understand the alerts received. Once we are through the mails; we understand which are the servers with errors and what was the action taken. I am sure this is the best possible way! :)
Next would be to go through one by one on all the above listed as part of daily check list. The check can be done in any order... no hard rule to follow :)

Ok, now that we know from where to start and also what all to check... the next thing would be to capture the results. Again it is the DBA who can develop his or her own format for capturing the results.

So, that is all I wanted to share for now.

For more reading on check list one can refer to following link.

Enjoy reading!

1 comment:

mary Brown said...

A IEEE project Domain is an interrelated arrangement of exercises, having a positive beginning and end point and bringing about an interesting result in Engineering Colleges for a particular asset assignment working under a triple limitation - time, cost and execution. Final Year Project Domains for CSE In Engineering Colleges, final year IEEE Project DOmains Management requires the utilization of abilities and information to arrange, plan, plan, direct, control, screen, and assess a final year project domains for cse. The utilization of Project Management to accomplish authoritative objectives has expanded quickly and many engineering colleges have reacted with final year IEEE projects Project Centers in Chennai for CSE to help students in learning these remarkable abilities in their respective domains.

Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

Post a Comment