SQL Workload Analysis

SQL Workload Analysis

IDERA, an Idera, Inc. company
+
+

Related Products

  • Google Cloud BigQuery
    1,983 Ratings
    Visit Website
  • AthenaHQ
    33 Ratings
    Visit Website
  • TeleRay
    6 Ratings
    Visit Website
  • Athena Security
    5 Ratings
    Visit Website
  • MongoDB Atlas
    1,650 Ratings
    Visit Website
  • Google Cloud Platform
    60,526 Ratings
    Visit Website
  • Google Cloud SQL
    548 Ratings
    Visit Website
  • DbVisualizer
    557 Ratings
    Visit Website
  • Vertex AI
    944 Ratings
    Visit Website
  • Windocks
    7 Ratings
    Visit Website

About

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run. Athena is easy to use. Simply point to your data in Amazon S3, define the schema, and start querying using standard SQL. Most results are delivered within seconds. With Athena, there’s no need for complex ETL jobs to prepare your data for analysis. This makes it easy for anyone with SQL skills to quickly analyze large-scale datasets. Athena is out-of-the-box integrated with AWS Glue Data Catalog, allowing you to create a unified metadata repository across various services, crawl data sources to discover schemas and populate your Catalog with new and modified table and partition definitions, and maintain schema versioning.

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
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Audience

Organizations that want to start running powerful database queries

Audience

database administrators for Microsoft SQL Server

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

API

Offers API

API

Offers API

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version
Free Trial

Pricing

$400 per instance
Free Version
Free Trial

Reviews/Ratings

Overall 4.5 / 5
ease 5.0 / 5
features 5.0 / 5
design 4.5 / 5
support 4.5 / 5

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Company Information

Amazon
Founded: 1994
United States
aws.amazon.com/athena/

Company Information

IDERA, an Idera, Inc. company
Founded: 2004
United States of America
www.idera.com/productssolutions/sqlserver/sql-workload-analysis

Alternatives

Alternatives

SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company
IDERA Precise for Databases

IDERA Precise for Databases

IDERA, an Idera, Inc. company
AWS Glue

AWS Glue

Amazon
SQL Sentry

SQL Sentry

SolarWinds
SQL Diagnostic Manager for SQL Server

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
SQL Doctor

SQL Doctor

IDERA, an Idera, Inc. company

Categories

Categories

Database Features

Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization

Database Monitoring Features

Anomaly Detection
Autodiscovery
Capacity Planning
Dashboard
Dependency Tracking
Historical Trend Analysis
Multitenancy
Notifications / Alerts
Performance Monitoring
Permissions / Access Controls
Predictive Analytics
Prioritization
Query Analysis
Resource Optimization
Troubleshooting

SQL Server Features

CPU Monitoring
Credential Management
Database Servers
Deployment Testing
Docker Compatible Containers
Event Logs
History Tracking
Patch Management
Scheduling
Supports Database Clones
User Activity Monitoring
Virtual Machine Monitoring

Integrations

AWS Secrets Manager
Amazon Transcribe
Anomalo
Azure Marketplace
Azure Virtual Machines
Bigeye
Klera
MSIGHTS
Meltano
Mode
Openbridge
Polytomic
Preset
Protegrity
SQL Server
Satori
Sifflet
Splunk User Behavior Analytics
Timbr.ai
Union Cloud

Integrations

AWS Secrets Manager
Amazon Transcribe
Anomalo
Azure Marketplace
Azure Virtual Machines
Bigeye
Klera
MSIGHTS
Meltano
Mode
Openbridge
Polytomic
Preset
Protegrity
SQL Server
Satori
Sifflet
Splunk User Behavior Analytics
Timbr.ai
Union Cloud
Claim Amazon Athena and update features and information
Claim Amazon Athena and update features and information
Claim SQL Workload Analysis and update features and information
Claim SQL Workload Analysis and update features and information