SQL Server Performance Tuning

ScaleSQL Consulting can identify and correct performance bottlenecks in your database server. We work on servers in Kansas City and around the world.

We use Profiler, ClearTrace, wait state analysis and Performance Monitor (perfmon) to identify bottlenecks. This lets us identify which resources are bottlenecks and the queries that are the biggest consume of those resources.

In many cases the performance problem can be corrected by additional indexes or rewriting queries. In some cases we need to look at memory usage, query plan reuse or parallelism.

The tools and approaches we use include: