So what is needed for a DBA Toolbox to deal with all the issues that arise for Dba’s?
This is what I’ve come up with so far. If you have more suggestions I would love to hear from others to fill out the list more. I’m not trying to make the perfect list at this point just looking for a good outline to start some discussion and find other things that might come up.
Maintenance
For Performance
Updating stat’s
Reindexing/defrag
File growth Control or monitoring
Stats monitoring,
Wait stats,
Perf counters,
For Integrity
Checkdb
Hardware level checking?
For Backup/recovery
Backup schedule/Program
Restore schedule
Disaster Mode
For Connection issues
For corruption
For down server/Suspect mode issues
Best Practices
For DB Design
For Sp programming
For Hardware Design
Pat