health check automation
TRANSCRIPT
1 Run Database Services – Database Health Check
GRY
Database Health Check Automation
Run Database Services
Josh Collins
3 Run Database Services – Database Health Check
Getting Images for the Health Check
Performance charts are images from DPA
4 Run Database Services – Database Health Check
• Ruby is an object oriented scripting language
• Ruby mimics user input and is very good at repetitive tasks such as gathering data and forming a PowerPoint
• Ruby easy to use and very intuitive to programmers
Why Ruby
5 Run Database Services – Database Health Check
• Eliminates hours of manual effort
• Allows the team to create more presentations with less effort
Why It Matters
6 Run Database Services – Database Health Check
• 18 images for 1 health check ~ 17 minutes• For 30 databases it would take a user an estimated 8.5 hours• To get all of the images for the same 30 databases, it took the program 36
minutes.
Cost savings: $11,303 per year
Traction