TRANSFORM: Automating Database Maintenance

TRANSFORM: Automating Database Maintenance

0.00

Speaker:
Sheri Radomsky, Accenture

Nonstop Database Administrators are a limited resource, and we want to make sure they spend their time doing things only humans can do. Automating routine maintenance reduces workload and increases employee engagement and satisfaction. DEVOPS is also putting additional pressure on DBA resources. We use a combination of tools to automate database maintenance and monitoring tasks, including Netbatch, Mars, and Prognosis as well as using SQLXpress to research issues and collect data related to queries. - cite several examples of routine tasks that are automated - space management, reloads, investigating performance issues, statistics, etc. Discuss previous attempted solutions and their limitations.

Add To Cart