Contact us

Madeira Data Solutions

Your Data, Our Solutions

Performance Tuning & 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 to save you money, as well as our own pre-written scripts finely tuned from frequent use.  When it’s helpful, we recommend third-party products we’ve personally tested to achieve the best results.

Qure Optimizer logoThe Qure Optimizer by DBSophic offers automatic identification and optimization of a whole database at once.  It also produces an easy-to-read report with clear suggestions of solutions that can be automatically implemented.  This tool is best used on large or complex databases systems with many common problems and can save both time and money.  In covering everything in the system, the Qure Optimizer makes many small improvements that add up to an overall better performance.