Menu
Performance Optimization & Site Reliability Engineering
Site reliability refers to the stability and quality of service provided by an application once it is live for users. Site reliability engineering (SRE) involves using software tools to automate tasks related to IT infrastructure, such as system management and application monitoring.
The engineering team at Periscope Labs was assigned to enhance performance and implement best practices in site reliability engineering for a major healthcare organization in North America.
SERVICE OFFERINGS
Services
Architecture Assessment
SQL Tuning
Middleware Tuning
OS Tuning
DevOps
Load Testing
Logging, Monitoring and Alerting
Tech Stack Used
Oracle RDBMS
PeopleSoft Application
WebLogic Web Server
Tuxedo Application Server
Problem Statement
The customer was facing performance and availability issues that affected OLTP end-users as well as batch processes.
They were looking for:
Performance optimization of specific OLTP transactions and batch processes
Monitoring capabilities and automation
Alerting Features
Logging and trend analysis of long-running transactions and processes
Solution
Following areas have been covered by the team:
Performance Optimization - SQL and Database Tuning
SQL Tuning - Financials System
SQL Tuning - HR System
SRE - Monitoring, Logging & Alerting/Notification
Rogue Runner
Tuxedo Application Server Monitoring
Weblogic Web Server Monitoring
Operating System Monitoring
Summary of Tasks Performed:
The performance optimization team completed many SQL Tuning activities and investigation into associated database performance issues.
Long running and high resource usage queries were prioritized by, firstly, business impact, and secondly, database and infrastructure impact.
For all tuned queries, a document has been provided with details of the changes, an explanation of the tuning, and the investigation process.
For alerting, Immediate notification by email (or other methods) of support teams that there is an issue with a component of the application now.
Monitoring & logging tools developed or configured as appropriate, that were suited for specific use cases.
For trend analysis, short to long term review of application performance with a view to configuration and sizing changes.
Contact
Get in touch
Dont be shy, Just tell us about your projects and we’ll figure out the best option for you.
- hello@periscopelabs.io
- +88 02 48810456, +880 1711 275 321 +1 646 267 9820
- Road No: 10, House No: 54, Apt: 1-A, Block: E, Banani, Dhaka - 1213, Bangladesh
- 516 Cherry Lane, Floral Park, NY 11001, USA
