Getting the most out of your database

Mark Gurry Associates (MGA) is best known for producing best selling performance tuning books and producing performance tuning software. Those that manage sites that have large numbers of application users and tight overnight batch windows know MGA as the Go To Company to when it comes to removing the performance risk from their business.

MGA is responsible for putting procedures and standards in place at the most mission critical sites to remove any risk of poor performance well before the code reaches production. Procedures are also put in place by MGA to ensure that the architecture selected, the design, the coding, the testing, the database setup, the application and web server setup, the hardware setup and the network setup are all of a quality that will provide best performance.

MGA can assist with the following performance related tasks:

• Tuning your production database and application code
  
  
• Putting procedures in place that will remove your sites performance risk
  
  
• Training in SQL performance tuning for DBAs, developers and other IT support staff
  
  
• Reviewing your application code for high performance and tuning where necessary prior to releasing to production
  
  
• Load testing and regression testing to ensure your critical transactions will perform well under load and that your setup is optimal
  
  
• Capacity planning and Web, App and Database Server setup advice
  
  
• RAC setup and Tuning
  
  
• PeopleSoft specialist performance tuning advice

MGA employees are attracted to work for the Company because of the Company's speciality in the performance tuning arena. Staff are hand selected for their performance tuning knowledge and breadth of experience. Many have come from sites that are tuned to cope with 10,000 users or more.

MGA EagleEye is a tool used to automate and speed the tuning process. MGA EagleEye is provided free of charge to all clients that acquire an MGA Performance Tuning Support Agreement. The support agreements also include performance tuning training with your code being tuned as part of the training course.

In addition to MGA EagleEye, which can be used to simulate load, MGA consultants are experienced in a number of load simulation tools including WAPT, Mercury Load Runner and OpenSTA. These tools, combined with MGAs experience in setting up, executing and evaluating load tests, provide organisations with a cost effective way of minimising the risk of performance issues when new application software is released to production environments.

For more information on our Performance Tuning & Load Testing Services, or any other MGA Products & Services, please contact us.