G&G Outfitters, Inc. Turns to DataStrike for SQL Support and SSRS Reporting

G&G considered a dedicated resource to meet the following goals:

‍

24x7 SQL Server monitoring and maintenance

‍

Implement robust system backups

‍

Craft and modify SSRS reports

‍

Provide predictable and optimized system performance

‍

Ensure 100% uptime and high availability for essential applications

Monitoring: 24x7x365 database and server monitoring (CPU, Disk Space, SMTP Check, Alerts)

‍

Tracking Metrics: Metric tracking for database performance (Page Life Expectancy, Lock Time, etc.)

‍

Data Cleansing: Automated SQL agent jobs to clean and reorganize data

‍

Backups: Setup of backups to meet required Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO)

‍

Data Restoration: Data restoration setup and Development/Testing environment

‍

Best Practices: Educational SQL Server best practices

‍

Configuration/Maintenance: Index maintenance scripts, configuring and maintaining the replication environment

Generation and modification of 30 SSRS reports within 7 months

‍

Consistent, predictable uptime and high availability for essential applications

‍

Enhanced database productivity and efficiency, jobs running correctly, and indexes updated

‍

Replaced and improved old applications with new report creation

‍

Client team’s enhanced understanding of third-party application data architecture