Performance Tuning and Optimization
If you have a performance problem and you don’t know where it’s coming from, call us right away and we’ll get to the bottom of it.
It could be a general system slowdown or a specific process or report that is taking too long to run, but you don’t know why and your business is stuck.
We’ll send in an expert consultant and figure out where the blockages are that are causing your system to slow down to a crawl.
There are two main approaches to performance tuning: either find and release the top 20% of processes that cause 80% of the problems, or fix specific problems and processes that work poorly.​
-
Some of the most common issues include:
-
Poorly written queries that require adjustment
-
Indexes not maintained that lead to fragmentation
-
Statistics that are outdated
-
Database configurations are not set properly
-
Hardware, storage, or network problem not identified
-
Architectural problems in the system requiring re-design
Performance tuning is our most popular service, and our consultants are highly experienced in hunting down any of these problems.
To identify bottlenecks, our team uses tools built in to SQL Server, as well as our own pre-written scripts finely tuned from frequent use. We also recommend our DBSmart Solution for comprehensive monitoring and alerts.