What does your checklist looks like?

Question

What does your checklist looks like?

Alejandro Santana

SSCommitted

Points: 1835
More actions
September 17, 2018 at 6:58 am

#368185

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!. 🙂

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

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

Lowell SSC Guru Points: 323504 More actions · Answer 1

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!

Alejandro Santana SSCommitted Points: 1835 More actions · Answer 2

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.