Performance Tuning & Sizing for ISVs2017-10-21T04:42:27+00:00

System Sizing Requirements and Database Performance Tuning for ISVs

Independent Software Vendors have a unique situation. Typically their expertise lies in development and functionality of the applications. But most applications require interaction with a database backend. Many ISVs do not have database experts on staff to handle all aspects of database performance tuning.  Application, hardware and system experts on are frequently on staff but Microsoft SQL and Oracle database performance experts rarely are.  In many cases, the clients of these ISVs are even less prepared. PTC can provide the missing link to assist the ISV to be successful and show support to their clients.

In the case where clients are hosting their own applications and data, PTC can assist in the definition and documentation of system sizing and configuration requirements for their client’s application environments, to provide a suggested configuration with best practices to the client. This can help avoid initial configuration mistakes that cause poor performance, which are not related to the ISVs application code, but may appear so to the client. We can analyze and recommend system configurations optimized for a specific application design and planned user and workload growth. A typical requirements document includes the following:

  • Server and storage specifications (including number of disks and RAID levels)
  • Operating system and database configuration (including database file layout)
  • System configuration and usage recommendations for small, medium, and large sized clients

We can also assist the ISV in testing and optimizing their application code before it gets released, thus helping to avoid client performance issues and complaints. We also work directly with ISV clients to troubleshoot issues in their own environment, either directly to the client, or thru a partnership with the ISV. This can be in the form of a specific project or a block of hours to help whenever an need arises.

Contact Us Today

*required field

PTC Update

Latest From the Blog

How to Remove the OEM 13c Host Agent Remotely

I do a lot of testing in my lab environment with a lot of different Oracle products including Oracle Enterprise Manager (OEM).  One of the things that I have run into is when I reinstall [...]

Configuring a PDB for Comparison in Oracle Veridata

Edward Whalen 04/16/2019 Oracle GoldenGate Veridata - Configuring a PDB for Comparison in Oracle Veridata I recently came across an interesting problem.  How do you point the Oracle Veridata Agent at an Oracle pluggable [...]

What Our Clients Say

“Performance Tuning was able to quickly troubleshoot and resolve many technical issues that often eluded other consulting companies we’ve worked with. I was most impressed by their quick response in emergency situations. They’ ve been instrumental in the delivery of Oracle technologies such as Oracle RAC, Grid Control and Data Guard.”

James Jech, Dell

“Performance Tuning was able to offer unique insights to database design and performance tuning optimization on a world class level. They did a superb job of load testing, which was cited by Microsoft (a team member) as, the best we’ve seen in three years and 50 customers to come through our SQL Server Performance Tuning Lab. This statement came from the SQL Server Product Group in Redmond – a tough crowd to please. In addition, they accelerated several products including our flagship Thomson ONE Analytics and were a key part of a project whose success has lead to case studies by Intel, Microsoft, and Unisys.”

Jeremy Lehman, Thomson

“The Instructor was able to customize the course slightly to meet the needs and levels of experience in the class. It was great to get some real hands on to cement in what was reviewed and explained.”

Chad Aberle, Microsoft

“We recently had a problem with SQL Server performance after introducing virtualization and a SAN in our server environment. After working with two different consulting companies without success, we contacted Performance Tuning Corporation. PTC rapidly set up a remote engagement with us, and within one week was able to identify a problem with a virtual device driver. We are very satisfied with the work PFC performed, and feel it is some of the best consulting money that we have spent in several years.”

Howard Brill, PHD, Monroe Plan

PTC has been phenomenal. It’s a scary time when your most critical data is being moved while users are in the system working. Especially on the heals of our previous vendor’s failed attempt. I can only describe it as a calming effect when true professionals are running the show.

IT Healthcare Manager, Opelousas General Health System

“We are very pleased with the work that PTC performed. They were able to extract information from SQL Server and use that information to identify the exact causes of our performance bottlenecks. They provided us with information, tools, and instructions on how we can locate the cause of our performance problems. The final report contained good information and gives us a benchmark for doing future performance reviews.”

Jon Robertson, MedEvolve

“This is a well balanced course (Optimizing Oracle RAC on Linux) covering all major topics from System Administration to Database Administration unlike most of the courses”

Manish Bijlani, RealtyData Corp.

Our Clients

Over 1000 clients from all industries have benefitted from our database services