Spreadsheet: 137274d1327030597-excel-2007-could-not-delete-checkboxes-degilcopy
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | PREVENTIVE MAINTENANCE SQL DBA MONITORING CHECKLIST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Frequency : Daily
 | Inspection Date :
 | 1 | HARDWARE / SERVER |  |  |  |  |  |  |  |  |  | STATUS |  | REMARKS
 | 1.1 | Physical hardware is turn on and in good condition |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 1.2 | Free disk space is more than 30% |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 1.3 | Physical hardware is connected to network |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 1.4 | Free disk space for database is more than 20% |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 1.5 | CPU utilization |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 1.6 | Memory utilization |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 1.7 | Network utilization |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 2 | OPERATING SYSTEM |  |  |  |  |  |  |  |  |  | STATUS |  | REMARKS
 | 2.1 | Operating system events monitored |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 2.2 | Hardware event logs |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 2.3 | System logs |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 2.4 | Application logs |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 2.5 | Security audit failures |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 2.6 | Other window logs |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 3 | SQL DATABASE HIGH AVAILABILITY |  |  |  |  |  |  |  |  |  | STATUS |  | REMARKS
 | 3.1 | Backup successfully created |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 3.2 | Backup successfully restored |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 3.3 | Offsite backup successfully created |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 3.4 | Offsite backup successfully restored |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 3.4 | Automatic backup process successfully run at midnight / as scheduled |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 3.5 |  |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 4 | SQL SERVER INSTANCE MONITORING |  |  |  |  |  |  |  |  |  | STATUS |  | REMARKS
 | 4.1 | SQL Server connectivity |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 4.2 | SQL Server service started |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 4.3 | SQL Server Agent service started |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 4.4 | SQL Server Reporting Services service started |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 4.5 | SQL Server Integration Services service started |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 4.6 | SQL Server Browser service started |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 4.7 | SQL Server [NAME] service started |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 4.7 | SQL Server Agent job is monitored |  |  |  |  |  |  |  |  |  | YES | NO
 | 4.8 | SQL Server Alert is monitored |  |  |  |  |  |  |  |  |  | YES | NO
 | 4.9 | SQL Server Log is monitored |  |  |  |  |  |  |  |  |  | YES | NO
 | 4.9 | SQL Server Agent log is monitored |  |  |  |  |  |  |  |  |  | YES | NO
 | 5 | DATABASE MONITORING |  |  |  |  |  |  |  |  |  | STATUS |  | REMARKS
 | 5.1 | Mdf file is increasing |  |  |  |  |  |  |  |  |  | YES | NO
 | 5.2 | LDF file is increasing |  |  |  |  |  |  |  |  |  | YES | NO
 | 5.3 | Tempdb size and performance |  |  |  |  |  |  |  |  |  | YES | NO
 | 5.4 | Blocking |  |  |  |  |  |  |  |  |  | YES | NO
 | 5.5 | Deadlocks |  |  |  |  |  |  |  |  |  | YES
 | 5.6 | Query performance |  |  |  |  |  |  |  |  |  | YES | NO
 | 5.7 | Indexing |  |  |  |  |  |  |  |  |  | YES | NO
 | 5.8 | Database corruption |  |  |  |  |  |  |  |  |  | YES | NO
 | 5.9 | Policy violation / Review security log |  |  |  |  |  |  |  |  |  | PASS | FAIL
 | 6 | SQL SERVER MONITORING TOOLS USED |  |  |  |  |  |  |  |  |  | STATUS |  | REMARKS
 | 6.1 | SQL Server Configuration Manager |  |  |  |  |  |  |  |  |  | YES | NO
 | 6.2 | SQL Server Alert |  |  |  |  |  |  |  |  |  | YES | NO
 | 6.3 | Performance monitor |  |  |  |  |  |  |  |  |  | YES | NO
 | 6.4 | Profiler/SQL Trace |  |  |  |  |  |  |  |  |  | YES | NO
 |  |  |  |  |  |  |  |  |  |  |  | YES | NO
 |  |  |  |  |  |  |  |  |  |  |  | YES | NO
 |  |  |  |  |  |  |  |  |  |  |  | YES | NO
 |  |  |  |  |  |  |  |  |  |  |  | YES | NO
 |  |  | Carried out by : |  |  |  |  |  | Checked by :
 |  |  | Name : |  |  |  |  |  | Name :
 |  |  | Designation : |  |  |  |  |  | Designation :
 |  |  | Department : |  |  |  |  |  | Department :
 |  |  | Date : |  |  |  |  |  | Date :
 |  |  |  |  |  |  |  |  | Signature :
 |  |  | Signature :
 |  | [NAME]
 |  | Item | Descripencies |  |  |  |  | Corrective Action |  |  |  |  |  | Date Closed
 |  |  | Carried out by : |  |  |  |  |  | Checked by :
 |  |  | Name : |  |  |  |  |  | Name :
 |  |  | Designation : |  |  |  |  |  | Designation :
 |  |  | Department : |  |  |  |  |  | Department :
 |  |  | Date : |  |  |  |  |  | Date :
 |  |  |  |  |  |  |  |  | Signature :
 |  |  | Signature :