image165

Database Performance Tuning

Is your database not as fast as it used to be? Through expert execution of SQL query writing, index optimization, and database architecture, I can improve the performance of your SQL Server database in a matter of hours, often without the need to buy more expensive hardware.

How does it work?

I will review your systems to determine where your bottlenecks are which are hurting your performance and target them directly. Most databases, even well-designed ones, have queries, indexes, or table relationships which are less than optimal. Using a “work smarter not harder” approach, I can often provide recommendations to improve your overall performance on the first day. More often than not, acceptable performance can be reached simply by optimizing your existing system, and in the cases where more powerful computer hardware is required, I will recommend targeted improvements to get the best gains for your budget.

Hardware bottleneck analysis

By logging utilization of your CPU, RAM, Disk, and Network resources, I can determine bottlenecks for most cost-effective improvements and gain insight into other potential improvements.

Trace of real-life load

A trace of real-life load on the server will allow me to analyze minute details of your situation in aggregate to make a variety of conclusions regarding indexing needs, bottlenecks, and architectural and SQL querying priorities.

Server settings review

A variety of seemingly simple settings can have a dramatic effect on overall performance. Some of them can be changed without consequence, and others cannot. I will review them with you to determine the best settings for your application.

Data type optimization

Data types used to store your information significantly affect the storage required for your data. This will influence overall database size, I/O performance on both read and write, and the size and time required for indexing, joining, filtering, and sorting operations. Careful analysis can often lead to large improvements with minimal effort.

Index tuning

An index can be the most powerful performance tool in a database. If properly written and used, it directs you to precisely the information you need. Improperly written, it can provide less improvement than it should, not get used at all, and even slow overall performance. Indexing tuning can improve the overall performance of a database in addition to targeted operations.

SQL analysis

I will target the most costly and noticeable SQL code in your database and analyze it for optimization opportunities. Poorly written code can fail to utilize even well-made indexes and have other performance consequences as well. Optimizing your SQL queries can directly affect your most noticeable operations and even improve overall server performance.