Database Tuning

SQL performance tuning consists of making queries of a relation database run as fast as possible.

Database Tuning Services are focused on determining the root cause of existing MS SQL Server, Oracle and PostgreSQL database performance problems.

When considering the various database designs, configurations and usages within complex IT environments, it is critical to trust in a DBA expert that has substantial experience providing database tuning and optimization effectively.

Starting with a 1-day high-level assessment that covers the database, operating system, storage, and network we provide a primary assessment detailing areas we will focus on. They may be, but not limited to the following areas:

  • SQL Statements causing excessive resource consumption
  • Instance tuning (memory, CPU, etc.)
  • Database Design including partitioning, indexes, etc.
  • Database storage configuration and I/O access patterns
  • Application access to the database
  • Resource contention
  • Replication and Clustering
  • Backup and Recovery

Once the initial assessment has been made, we will determine the root cause of the performance problems and begin a plan for validation and testing of solutions.

Plans are split into Short-Term, Mid-Term and Long-Term remedies:

  • Short-Term: Changes that can be easily made and removed if they do not provide positive results.
  • Mid-Term: Changes that have a larger developmental impact but do not affect any application code.
  • Long-Term: Changes to hardware including servers and storage. These recommendations usually cannot be implemented immediately.