Skip to main content
 
Português English Español
Go Search
Ampsoft
Institutional
Products
Services
Technology
Contact Us
  

Services of Tuning and Performance 

Ampsoft is specialist in Tuning and Performance services for systems developed based on the Microsoft plataform (Framework .NET and SQL Server).

Our services aim to identify the possible causes of applications and database performance issues, and create solutions to optimize data processing by applying advanced programming techniques combined with the existing technological resources. 
 

 Batch and Online Applications


Analysis of best practices in developing

1. Code redundancy and verifications
2. Excessive use of loops
3. Repetitive queries to database
4. Logic programming generating processing bottlenecks

Multi-threads / Parallellism
1. Creation of class for queue monitoring

2. Utilization of the asynchronous resources System.Thread and delegates
3. Verifying methods with repetition characteristics to re-implement them using parallelism
4. Changing methods implementing multithreading

Database


Physical Model

1. Table analysis for performance best practices
2. Routine monitoring and index creation for faster queries
3. Tables partitioning and columns types

Programming Logic

1. Logic changing in WHERE clause for better response time
2. Changes in JOIN clauses to make smaller queries and use less I/O resources
3. Reduced use of cursors and loops that are not needed

SQL Server Service Broker

1. Database creation for queue monitoring
2. Verifying routines with repetition characteristics to re-implement them using parallelism
3. Changing methods to implement Service Broker

Our work significantly optimized batch and online applications developed with Microsoft technology and Intel-based servers, with support from the partnerships: 

Intel - Intel® Software Partner Program: Tools, knowledge and support needed to optimize the resources of Intel processors at the Ampsoft solutions. 

Microsoft - Microsoft® Certified Partner: Support and software needed to optimize the applications processing developed on Microsoft platform at the Ampsoft solutions.

Ampsoft | Institucional | Produtos | Tecnologia | Serviços | Fale Conosco