In a nutshell, Qure analyzes all the aspects of your database and generates pinpoint recommendations (including corrective code) for performance optimization in 4 main areas:

1. Smart Indexing™ - Create, Drop and Modify Indexes for Best Overall Performance

Creating an index to improve performance of a single query is one of the oldest tricks in the book. However, creating an index also has its drawbacks, slowing down INSERTs, UPDATEs, and other data modifications.

For this reason, creating the "optimal index" for each and every query is not the best strategy as this will result in numerous indexes which may hurt performance.

2. Query Syntax Optimization

The specific syntax a query uses can have a significant effect on its performance - even the best indexes won’t help if a query is written in a manner that prohibits optimal performance. This is true for all T-SQL code, whether in Stored Procedures, Views, Functions, or ad-hoc Queries.

Choosing the most efficient syntax is a tricky job. Qure automatically does so by evaluating numerous parameters for each query and generating pinpoint recommendations for query rewrites, including the actual recommended code. For example:

As Qure may produce hundreds of rewrite recommendations, Qure also estimates the potential performance impact of each rewrite. This enables you to implement the most effective rewrites first and get a maximal performance boost in minimum time.

3. Schema Optimization

The database schema is the foundation for all database operations. Qure performs a comprehensive statistical analysis of the data and its usage patterns and may suggest modifying the schema to enhance performance.

Here are some schema optimization recommendations Qure might suggest for your database:

• Changing column data types

• Adding or removing constraints

• Correcting potential design anomalies

Qure generates recommendations for schema changes and shows you their estimated potential impact on overall performance, so you can decide if, when, and in what order to implement these recommendations.

4. Additional Optimizations

This category includes dozens of miscellaneous performance tuning recommendations, which may have a huge impact on performance.
For example:

• Coding technique best practices violations

• Maintenance optimization recommendations

• Hint usage

• Potentially erroneous queries

• Database and server settings

There are probably thousands of possible tweaks and optimizations that might improve the performance of an SQL Server database.

In a standard optimization process, a real life optimization expert spends a considerable amount of time studying the database. The expert then prepares a theory regarding the optimal optimization technique, and finally performs a test to prove that theory.

If the test results in a good enough performance improvement, the same optimization technique is applied to the operational database. If not, the trial and error process is repeated.

This process usually takes a long time – in some cases, more than a year – and in most cases only a "good enough" performance improvement is achieved.

Qure changes all that – it provides you with accurate, tested, and optimal recommendations by using an automatic benchmark process that applies all recommendations on a copy of the operational database and measures the actual effect of these recommendations on your database activities. Qure provides detailed figures regarding the performance impact on all aspects of resource consumption – Logical and physical reads, CPU, writes and duration.

The entire benchmark process may take anywhere from a few hours to a few days.

This enables you to quickly apply the recommendations that proved to have the highest impact on your database performance and avoid the trial and error cycle of standard methodologies.

A single database tweak has the potential to improve performance, but more often than not, a single tweak will not solve a major performance problem.

However, a truly dramatic performance improvement is reached when you combine the performance improvements gained by the four techniques included in Qure:

• Creating optimal indexes

• Rewriting queries for better performance

• Applying schema optimizations

• Applying additional database performance optimizations

That is the reason why Clalit Health Services, the second largest HMO in the world, had this to say about Qure: "Qure's recommendations are deep-rooted and fundamental; Qure touches areas in the database that we wouldn't have reached otherwise. It would take months of a skilled DBA to do what Qure has completed in one day."  Read More...

 

Eyeblaster, a global leader in digital marketing, noted:
"Qure is very impressive, I consider it as a MUST tool for any organization using MSSQL"  Read More...