Oracle Autonomous DatabaseOracle
|
SQL Workload AnalysisIDERA, an Idera, Inc. company
|
|||||
Related Products
|
||||||
About
Oracle Autonomous Database is a fully automated cloud database that uses machine learning to automate database tuning, security, backups, updates, and other routine management tasks traditionally performed by DBAs. It supports a wide range of data types and models, including SQL, JSON documents, graph, geospatial, text, and vectors, enabling developers to build applications for any workload without integrating multiple specialty databases. Built-in AI and machine learning capabilities allow for natural language queries, automated data insights, and the development of AI-powered applications. It offers self-service tools for data loading, transformation, analysis, and governance, reducing the need for IT intervention. It provides flexible deployment options, including serverless and dedicated infrastructure on Oracle Cloud Infrastructure (OCI), as well as on-premises with Exadata Cloud@Customer.
|
About
Monitor and diagnose detailed database wait states and application transactions. Problematic SQL queries can severely reduce the performance of SQL Server and the business-critical applications that it supports. With the SQL Workload Analysis add-on, continuously monitor and analyze server workload, leverage the simple user interface that focuses on wait states and application performance, and troubleshoot problematic SQL code from changes made to database applications. Perform real-time analysis with continuous SQL sampling intervals. Know instantly where databases are spending time. Quickly isolate slow SQL statements and drill down for actionable advice. Investigate historical query plan trends. Utilize automatic recommendations to improve query performance.
|
|||||
Platforms Supported
Windows
Not Supported
Mac
Not Supported
Linux
Not Supported
Cloud
Supported
On-Premises
Supported
iPhone
Not Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
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
|
|||||
Audience
Data engineers and developers in need of a solution for building and deploying scalable applications with minimal administrative overhead
|
Audience
database administrators for Microsoft SQL Server
|
|||||
Support
Phone Support
Supported
24/7 Live Support
Supported
Online
Supported
|
Support
Phone Support
Supported
24/7 Live Support
Not Supported
Online
Supported
|
|||||
API
Offers API
Not Supported
|
API
Offers API
Not Supported
|
|||||
Screenshots and Videos |
Screenshots and Videos |
|||||
Pricing
$123.86 per month
Free Version
Not Supported
Free Trial
Supported
|
Pricing
$400 per instance
USD 400 per instance with first year maintenance included; add-on to SQL Diagnostic Manager for SQL Server, together with SQL Query Tuner
Free Version
Not Supported
Free Trial
Supported
|
|||||
Reviews/
|
Reviews/
|
|||||
Training
Documentation
Supported
Webinars
Supported
Live Online
Supported
In Person
Supported
|
Training
Documentation
Supported
Webinars
Supported
Live Online
Not Supported
In Person
Not Supported
|
|||||
Company InformationOracle
Founded: 1977
United States
www.oracle.com/autonomous-database/
|
Company InformationIDERA, an Idera, Inc. company
Founded: 2004
United States of America
www.idera.com/productssolutions/sqlserver/sql-workload-analysis
|
|||||
Alternatives |
Alternatives |
|||||
|
|
||||||
|
|
|
|||||
|
|
||||||
|
|
|
|||||
Categories |
Categories |
|||||
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
Not 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
Not Supported
|
||||||
Integrations
Amazon EC2
Not Supported
Azure Virtual Machines
Not Supported
JSON
Supported
List & Label
Supported
Oracle AI Data Platform (AIDP)
Supported
Oracle Cloud Infrastructure
Supported
Oracle Database
Supported
Oracle Database@AWS
Supported
SQL
Supported
SQL Server
Not Supported
|
Integrations
Amazon EC2
Supported
Azure Virtual Machines
Supported
JSON
Not Supported
List & Label
Not Supported
Oracle AI Data Platform (AIDP)
Not Supported
Oracle Cloud Infrastructure
Not Supported
Oracle Database
Not Supported
Oracle Database@AWS
Not Supported
SQL
Not Supported
SQL Server
Supported
|
|||||
|
|
|