- Connectivity: Make sure each database is available and accessible both by logging in via user applications, as well as running test scripts.
- Backups: Check database and log backups, archiving and offsite storage.
- Events: check all database logs, application logs and system logs, Agent history, device logs, NIC logs etc. Investigate any job failures
- Processes: Check that all required processes on the server are running, including Replication
- Integrity: Perform all database and server integrity checks; look for objects that break rules
- Indexes: Check on indexes to see if they are being used, need re-creating, or if any are missing
- Volumetrics: Check resources on the server such as files sizes and disk space, and monitor growth
- Performance: Check application performance, and performance statistics, using the Perfmon tool; research and resolve any issues.
- Procedures: Check all Disaster Recovery Plans
- Security: Look for security policy violations
Wednesday, May 21, 2008
The DBA Daily Checklist
Simple-Talk has compiled a checklist for DBA. They are as below:
Subscribe to:
Post Comments (Atom)
Popular Posts
-
According to a report in TodayOnline , Temasek-linked firms may post lower dividends this year. Even billionaire Warren Buffett's Berksh...
-
Singapore’s Land Transport Authority has just released an updated official MRT map including one additional station on the North East Line (... -
*********** Try to sleep now, close your eyes Soon the birds would stop singing Twinkling stars, are shining bright They'll be watch...
-
Robocopy, short for "Robust File Copy" is an advanced command-line utility included in Windows. It's designed to copy files an...
-
I would like to apologize that sigining of my guestbook is not possible at the moment due to an unexpected bug. There is already 74 entries ...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.