Productqure logo

What is Qure?

Qure for SQL Server is an innovative software solution that automatically analyzes a database and generates recommendations for optimizing its performance.
Using only an offline copy of the production database, and a standard SQL Server trace, Qure analyzes multiple aspects of the database and generates recommendations that include instantly applicable correctional scripts for optimizing its performance.

Qure turns the art of database performance optimization into a straightforward automatic procedure.

Learn more about how Qure works

 

What Makes Qure Highly Effective?

  • Qure analyzes the database from multiple aspects, considering the cross-effects of each recommendation on all aspects of the database activity
  • Qure automatically provides accurately measured and verified recommendations
  • Qure provides executable scripts for most recommendations and enables immediate implementation
  • Qure uses advanced, proprietary AI algorithms for unparalleled efficiency

Download Qure FREE trial and discover how much your database performance can be improved!


How does Qure optimize your database?


1. Smart Indexing

Qure recommends creating, removing and modifying indexes for best overall performance.
Qure evaluates all possible indexes for a query and then uses heuristics to combine the indexes for all queries, guaranteeing that:

  • Redundant indexes are eliminated
  • Indexes have the highest performance impact for as many queries as possible
  • The creation and dropping of indexes produces a significant, database-wide performance improvement

2. Query Syntax Optimization

Qure evaluates numerous parameters for each query and generates pinpoint recommendations for query rewrites, including correctional scripts!

Query rewrite example
 
The following query retrieves all orders made in 1997 and uses the YEAR function, which may prevent efficient index use:
This query can be rewritten without the YEAR function, potentially enabling efficient index seeking. In this case, Qure provides the following alternative syntax recommendation:
SELECT *
FROM Orders AS o
WHERE YEAR(OrderDate) = 1997
SELECT *
FROM Orders AS o
WHERE OrderDate >= ('1997-01-01T00:00:00')
AND
OrderDate < ('1998-01-01T00:00:00')


3. Schema Optimization

Qure evaluates the scehma structure and can recommendt changing column data-types, adding or removing constraints and correcting potential design anomalies.
Qure performs a comprehensive statistical analysis of the data and its usage patterns and may suggest modifying the schema to enhance performance.

4. Additional Optimizations

Miscellaneous performance tuning recommendations, which may have a huge impact on performance
For example:

  • Coding tecnhiques and best practices violations
  • Maintenance optimization
  • Hint usage
  • Potentially erroneous queries
  • Database and server settings
Download Qure