PADMAVATI TECHSYS PVT LTD.
Quality Through Technology Systematically
Home   ::   Case Study
CASE STUDY
Current Case Studies.

1.0 ONLINE BUSINESS SYSTEM.

Client environment

Our client was running a heavy engineering fabrication industry. There are stand alone system department wise with local database. No Backup Management due to local database. No integration with each department and each business process.

Operating System

• Windows 2003 Server

Hardware

• 1 CPU HP Server

Database

• MS SQL Server

Problem Statement

• Lack of integration with each Business process

• No Back up Management

Our Solution

We did the analysis of the application on an end-to-end basis. We looked at the database configuration, application configuration, storage and network configuration.

Heavy queries were being run by the application support team for generating reports for their day-to-day and monthly analysis of business. These queries were consuming most of system resources. These queries were running concurrently with branch online business application, branches were getting slow response of business system application impacting their business. These queries were identified and sent to the application team for fine-tuning.

Client Benefits

• Response time improved substantially for each department.

• Reduced workload on production system and significantly increased application availability.