Looking for SQL Server Daily Checklist Template?

Asked By 30 points N/A Posted on -
qa-featured

Hello Experts!

Can anyone please help me? Is there a SQL server daily checklist template which I can use as basis? I am not familiar with SQL server daily checklist and if anyone had experienced this, please share your expertise. Also, it would be nice if you can share your method of creating the template, your encountered problems and difficulties when using the program. I could save time when I have the complete checklist template, so please help me.

Thank you!

Alex Baker

SHARE
Best Answer by Frazier Rothe
Answered By 0 points N/A #150575

Looking for SQL Server Daily Checklist Template?

qa-featured

 

 

 

 

Hello,
 
For your checklist template, you might want to check on the following.
 
  • Backup databases
  • Check if all backup script or schedules are actually running.
  • Save a copy of SQL log files periodically and remove them after a reasonable time.
  • Review queries. You might find out that some can still be improved.
  • Optimize SQL indexes.
  • Do checks on database integrity               
  • Monitor SQL Server for downtime and figure cause of downtime if there are any.           
  • Check database growth. You might find the growth unreasonable.
  • Audit database security
  • Check SQL event logs
  • React to issues found on the event logs.
  • If there are have fail-over servers, do checks on it.
  • Lastly, test the backup files if it can be restored on a different server

 

Best Answer
Best Answer
Answered By 0 points N/A #150576

Looking for SQL Server Daily Checklist Template?

qa-featured

Hi Alex,

When referring to a health check procedure there is not a standard about this, but certainly I can provide you some real good info on how to continuously maintain your SQL server healthy: 

1. You will have to check the Operating System

2. You should check Hardware Status

3. You should check DB Settings

4. You should check SQL server Settings

5. You should check Security of SQL Server

6. You should check Logs

7. You should check KPI-s of the system 

8. You should have a proactive monitoring system set up on the SQL Server to report any alerts

I Would Suggest you to keep in mind the following when conducting the Health check :

1. Perform the Health Check at predefined intervals (maybe every week or every month)

2. Create a documentation to preserve the data output from the health check

3. If any issue is found than correct it after Health check process is finished.

4. Keep track of all saved documentation for future use.

5. You should be  sure to allocate enough space on critical databases and transaction logs.

6. Make sure that no other user beside Administrator can perform health Check tasks

 

Hope this helps ,

Cheers,

Frazier

Related Questions