Through our partnership with DBSophic, SQL Sentry customers can leverage the combined power of SQL Sentry Performance Advisor and Qure Optimizer to analyze and improve the overall performance of their SQL Server workload. Optimization recommendations can include adding and dropping indexes, schema changes, even re-writing entire queries and batches. Qure Optimizer runs the workload you specify against a copy of your production database, makes actual changes, then re-runs the workload against the changes to make sure they lead to better performance - recommendations that have actually been proven to improve your workload.
Advantages of using Qure Optimizer include:
- The workload definition is extracted from your existing SQL Sentry repository instead of a trace you create and run from scratch, leveraging data SQL Sentry is already collecting, eliminating additional load on your server.
- You can tune your entire workload in a single process rather than tuning individual objects or queries one at a time.
- Since the analysis also re-runs the entire workload, you can know exactly what you will gain in terms of CPU, I/O and duration improvements.
- The entire process works with a copy of your production database, so you do not risk untested changes in your live environment. The optimized copy of your database becomes the source for migrating selected schema and query changes to production.
For more details, check out Aaron's blog: Using Qure Optimizer.
The SQL Sentry Power Suite provides a complete performance monitoring and
optimization solution for Microsoft SQL Server by combining both
Performance Advisor for SQL Server and
Event Manager. The suite also provides a 20% cost advantage
compared to purchasing both products separately. If you also have Analysis Services in your
SQL Server environment, check out the SQL Sentry BI Suite for coverage of the entire Microsoft BI Platform.
Power Suite Overview
The SQL Sentry Power Suite provides a complete performance monitoring and optimization solution for Microsoft SQL Server by combining both Performance Advisor for SQL Server and Event Manager.
SQL Sentry Power Suite + Qure Optimizer is available as a Quick Start Pack, which
includes (5) In-depth performance optimizations using Qure Optimizer, (5) SQL Sentry licenses of Performance Advisor for SQL Server, and (5) SQL Sentry licenses of Event Manager
for SQL Server. First year annual software maintenance is required and provides technical support via e-mail and phone, fixes and updates and free version upgrades.
For a complete listing, view the product price list and online store.
|SQL Sentry Power Suite + Qure Optimizer
|Power Suite for SQL Server + Qure Quick Start 5-Pack
(5) Performance Advisor for SQL Server
(5) Event Manager for SQL Server
(5) In-depth performance optimizations using Qure Optimizer
* Quick Start 5-Packs are only available to new customers with a limit of 1 per company. The first year annual software maintenance is included in all Quick Start 5-Packs. Subsequent years will be billed at the standard maintenance rate.