Clicky

Infrastructure Support

Database Administration – SQL Server

Challenges

  • Limited documentation
  • Competing priorities
  • Limited alert setup for database functions
  • Application dependency on lower functions

Solution Approach

  • SQL Server Provisioning
  • SQL Server Upgrade
  • SQL Server Monitoring to keep alive(24*7)
  • Disk Spaces, CPU and Memory verification
  • Database Backups and Recovery
  • Database refresh from higher to lower environment
  • Database Patching
  • Database User Management
  • Database Indexes
  • Debugging Application related DB issues
  • Achieve SLAs

ATMECS’s Contribution

  • Implemented a robust monitoring system to monitor SQL Services status and CPU, Memory and Disk level thresholds
  • Placed a PowerShell script to monitor and report all the error events in production error logs
  • Automated the process to perform DB refresh from higher to lower environments
  • Automated the process to rebuild index offline/online on periodic basis
  • Placed scripts to generate various types of application reports
  • Developed jobs for Index Optimization
  • Developed scripts to auto failover the SQL Instances