IDERA Precise for DatabasesIDERA, an Idera, Inc. company
|
SQL Query TunerIDERA, an Idera, Inc. company
|
|||||
| IDERA Precise for Databases | SQL Query Tuner | |||||
|---|---|---|---|---|---|---|
Related Products
|
||||||
IDERA Precise for Databases:
About
Precise for Databases helps database administrators to find and fix database performance problems in physical, virtual, and cloud environments. Unlike its competition, it provides deep database optimization, isolation of problems and causes, scalable deployment, what-if analysis for changes, and history, trending, and planning. Precise for Databases ensures that databases perform at peak efficiency. It captures, measures, and correlates performance metrics from all critical components of the system. It then detects and corrects the root cause of database and transaction performance problems before they become noticeable for databases and their related applications. Monitor Microsoft SQL Server, Oracle Database, IBM Db2, and SAP Sybase ASE. For each of these database platforms, the interface of Precise looks and behaves the same to minimize the learning curve. Precise for Databases samples the monitored databases once per second or more frequently, has low overhead (typically 1%).
|
SQL Query Tuner:
About
SQL Query Tuner helps database administrators to tune and profile SQL code for SQL Server. Unlike its competition, it provides automated SQL tuning and performance optimization suggestions with color-coded index analysis, database profiling of wait-time analysis for a single stored routine or an entire data source, SQL stress load testing to simulate a production environment with parallel users and executions over a specific period of time or execution cycle, and review of SQL execution and performance costs using explain plans.
|
|||||
IDERA Precise for Databases:
Platforms Supported
Windows
Supported
Mac
Not Supported
Linux
Not Supported
Cloud
Not Supported
On-Premises
Not Supported
iPhone
Not Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
SQL Query Tuner:
Platforms Supported
Windows
Supported
Mac
Not Supported
Linux
Not Supported
Cloud
Not Supported
On-Premises
Not Supported
iPhone
Not Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
|||||
IDERA Precise for Databases:
Audience
Database administrators for Microsoft SQL Server, Oracle Database, Sybase ASE, and IBM Db2
|
SQL Query Tuner:
Audience
database administrators for Microsoft SQL Server
|
|||||
IDERA Precise for Databases:
Support
Phone Support
Supported
24/7 Live Support
Not Supported
Online
Supported
|
SQL Query Tuner:
Support
Phone Support
Supported
24/7 Live Support
Not Supported
Online
Supported
|
|||||
IDERA Precise for Databases:
API
Offers API
Not Supported
|
SQL Query Tuner:
API
Offers API
Not Supported
|
|||||
IDERA Precise for Databases:
Screenshots and Videos |
SQL Query Tuner:
Screenshots and Videos |
|||||
IDERA Precise for Databases:
PricingRequest a quote for special discounted pricing.
Free Version
Not Supported
Free Trial
Supported
|
SQL Query Tuner:
Pricing
$400 per instance
USD 400 per instance with first maintenance included; add-on to SQL Diagnostic Manager for SQL Server, together with SQL Workload Analysis
Free Version
Not Supported
Free Trial
Supported
|
|||||
IDERA Precise for Databases:
Reviews/
|
SQL Query Tuner:
Reviews/
|
|||||
IDERA Precise for Databases:
Training
Documentation
Supported
Webinars
Supported
Live Online
Not Supported
In Person
Not Supported
|
SQL Query Tuner:
Training
Documentation
Supported
Webinars
Supported
Live Online
Not Supported
In Person
Not Supported
|
|||||
IDERA Precise for Databases:
Company InformationIDERA, an Idera, Inc. company
Founded: 2004
United States
www.idera.com/precise-for-databases
|
SQL Query Tuner:
Company InformationIDERA, an Idera, Inc. company
Founded: 2004
United States of America
www.idera.com/productssolutions/sqlserver/sql-query-tuner
|
|||||
IDERA Precise for Databases:
Alternatives |
SQL Query Tuner:
Alternatives |
|||||
| IDERA Precise for Databases: |
SQL Query Tuner:
|
|||||
| IDERA Precise for Databases: |
SQL Query Tuner:
|
|||||
|
IDERA Precise for Databases:
|
SQL Query Tuner:
|
|||||
|
IDERA Precise for Databases:
|
SQL Query Tuner:
|
|||||
IDERA Precise for Databases:
Categories |
SQL Query Tuner:
Categories |
|||||
IDERA Precise for Databases:
Database Features
Backup and Recovery
Not Supported
Creation / Development
Not Supported
Data Migration
Not Supported
Data Replication
Not Supported
Data Search
Not Supported
Data Security
Not Supported
Database Conversion
Not Supported
Mobile Access
Not Supported
Monitoring
Supported
NOSQL
Not Supported
Performance Analysis
Supported
Queries
Supported
Relational Interface
Not Supported
Virtualization
Not Supported
Database Monitoring Features
Anomaly Detection
Supported
Autodiscovery
Not Supported
Capacity Planning
Supported
Dashboard
Supported
Dependency Tracking
Not Supported
Historical Trend Analysis
Supported
Multitenancy
Not Supported
Notifications / Alerts
Supported
Performance Monitoring
Supported
Permissions / Access Controls
Not Supported
Predictive Analytics
Supported
Prioritization
Not Supported
Query Analysis
Supported
Resource Optimization
Supported
Troubleshooting
Supported
SQL Server Features
CPU Monitoring
Supported
Credential Management
Not Supported
Database Servers
Not Supported
Deployment Testing
Not Supported
Docker Compatible Containers
Not Supported
Event Logs
Not Supported
History Tracking
Supported
Patch Management
Not Supported
Scheduling
Not Supported
Supports Database Clones
Not Supported
User Activity Monitoring
Supported
Virtual Machine Monitoring
Supported
Application Performance Monitoring (APM) Features
Baseline Manager
Supported
Diagnostic Tools
Supported
Full Transaction Diagnostics
Supported
Performance Control
Supported
Resource Management
Supported
Root-Cause Diagnosis
Supported
Server Performance
Supported
Trace Individual Transactions
Supported
|
SQL Query Tuner:
Database Features
Backup and Recovery
Not Supported
Creation / Development
Not Supported
Data Migration
Not Supported
Data Replication
Not Supported
Data Search
Not Supported
Data Security
Not Supported
Database Conversion
Not Supported
Mobile Access
Not Supported
Monitoring
Supported
NOSQL
Not Supported
Performance Analysis
Supported
Queries
Supported
Relational Interface
Not Supported
Virtualization
Not Supported
Database Monitoring Features
Anomaly Detection
Supported
Autodiscovery
Not Supported
Capacity Planning
Not Supported
Dashboard
Supported
Dependency Tracking
Not Supported
Historical Trend Analysis
Supported
Multitenancy
Not Supported
Notifications / Alerts
Not Supported
Performance Monitoring
Supported
Permissions / Access Controls
Not Supported
Predictive Analytics
Supported
Prioritization
Not Supported
Query Analysis
Supported
Resource Optimization
Not Supported
Troubleshooting
Not Supported
SQL Server Features
CPU Monitoring
Supported
Credential Management
Not Supported
Database Servers
Not Supported
Deployment Testing
Supported
Docker Compatible Containers
Not Supported
Event Logs
Not Supported
History Tracking
Supported
Patch Management
Not Supported
Scheduling
Not Supported
Supports Database Clones
Not Supported
User Activity Monitoring
Not Supported
Virtual Machine Monitoring
Not Supported
|
|||||
IDERA Precise for Databases:
Integrations
SQL Server
Supported
Amazon EC2
Not Supported
Azure Virtual Machines
Not Supported
Collate
Not Supported
IBM Db2
Supported
IBM InfoSphere Data Architect
Not Supported
Oracle Database
Supported
SAP Adaptive Server Enterprise (ASE)
Supported
Safyr
Supported
Zenduty
Supported
|
SQL Query Tuner:
Integrations
SQL Server
Supported
Amazon EC2
Supported
Azure Virtual Machines
Supported
Collate
Supported
IBM Db2
Not Supported
IBM InfoSphere Data Architect
Supported
Oracle Database
Not Supported
SAP Adaptive Server Enterprise (ASE)
Not Supported
Safyr
Not Supported
Zenduty
Not Supported
|
|||||
|
IDERA Precise for Databases:
|
SQL Query Tuner:
|