Years of Large-scale ERP experience with Fortune
500 companies, position us to provide you with optimum system performance
and optimum use of your system resources.
NADA's expertise covers ERP application specific requirements from
the web interface and the application logic to the internals of
the database, application server and operating system. Performance
is analyzed at each tier to indicate where the bottlenecks are.
This ensures optimization is applied where it is most needed and
the problems are immediately resolved at the source.
Our services include:
- Application Benchmarks
- Application Configuration guidelines
- Performance code standards
- Application Load Testing
Our methodology includes the following:
- Analysis of the overall application functions and architecture
- Server analysis. We will usually begin by collecting Oracle
or SQL Server and OS statistics
- Stored procedure and SQL analysis. We also look at the system
in terms of what it is doing and try to determine if performance
can be enhanced by either modifying SQL statements or execution
plans
- Schema analysis. Indexing, partitioning or distributing the
database
|