Server Automation
The end of the year holidays are nearly here. Now’s the time to make sure your automated tasks are tuned up so that you can enjoy a great holiday without interruptions.
Here’s a quick checklist:
- Backup Strategy is working and validated for adequate space
- Automated tuning processes are working
- Disk allocation is adequate
- Tables are defragmented
- Databases are passing Database Consistency Checks
- Alerts are working and directed to the appropriate contact
Any one of these bullets is big enough to write a chapter in a book. That can be daunting for the database professional let alone the accidental DBA; and the level of pain only increases with the number of database servers, databases, etc. So, if you’re not sure you have your checklist all sorted out, it’s time to start finding some help before you’re called to come rescue a critical system during the middle of a holiday meal.
Why not write in with your favorite tip for implementing your holiday checklist? Drop me an Email at btaylor@sswug.org if you would like to share your thoughts with other readers.
Cheers,
Ben
SSWUG-TV
Did you catch the insights from data management experts Thomas LaRock, Sarah Barela and Malathi Mahadevan on SSWUG-TV? Watch the Show
$$SWYNK$$
Featured White Paper(s)
How to Implement an Effective SharePoint Governance Plan
Written by AvePoint
Moving past the "what" and "why" of governance, an even… (read more)
Featured Script
defrag — another way
run the simple query and use its result to rebuild indexes… (read more)