What does your checklist looks like?

  • Good morning fellows!

    I have been wondering what does your everyday database/instance checklist looks like?
    In ours we have the next questions,

    We make it per instance.

    -Can you log into the instance?
    -Is the SQL Agent up?
    -Date of the latest SQL Backup
    -SQL Server Data files % < 10? True or False
    -Server memory %>90? True or False
    -SQL Server Error Log: Post any error if found
    -Partitions % < 10 ? True or False

    I want to hear about yours, if you have something so we can expand ours i would like to hear it, if you can post anything to help and discuss i think it would be great.

    Thanks a lot for reading this post, have a great week!. 🙂

  • Alejandro I have pondered this over time,and there is a difference between informational reports and exception reports for me.
    An informational report might have lots of info, names of databases,configuration info, maybe even schema info, and that is good for documentation.not something i need daily, though
    examples of that for me are:
    sysadmins on server
    DatabaseList
    is Server Cluster
    DBSpaceUsed
    Server Logins
    DB Compatibility
    Service Accounts
    Replication info 
    LinkedServers
    Database Mail
    AllJobs
    Maintenance Plans
    three of four part DB References
    UserPermissions
    Policies
    RegistryDirectories
    LoginPasswordReset
    Weak Passwords
    SQLLogins 

    but daily reports for me are exceptions. what i need to look at and maybe fix.

    I have been spending a lot of time producing reports of exceptions, and I scan my Central Management Servers collections each day.
    if i cannot connect, it goes on the exception report, and then from there, i scan for a lot of things:
    for example, from your list, i don't want to know the date of the latest backup, but rather, is there any instances where the last full backup is older than 8 days, or a differential backup older than 2 days.
    my list of exceptions is:
    Server Inventory
    Backup Daily exceptions
    SQL Log - Daily exceptions
    Failed Jobs - Daily exceptions
    Failed db Mail
    PreferredNodes not on correct node
    Mirroring not syncronized
    Database Compatibility not max
    Orphaned DbUsers
    Offline Databases

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Thanks alot for your reply Lowell! you gave me a few new ideas.

    I'm looking forward to the other users reply if they can!

    Greetings.

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

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