SQL ServerMicrosoft
|
SQL Workload AnalysisIDERA, an Idera, Inc. company
|
|||||
Related Products
|
||||||
About
Intelligence and security are built into Microsoft SQL Server 2019. You get extras without extra cost, along with best-in-class performance and flexibility for your on-premises needs. Take advantage of the efficiency and agility of the cloud by easily migrating to the cloud without changing code. Unlock insights and make predictions faster with Azure. Develop using the technology of your choice, including open source, backed by Microsoft's innovations. Easily integrate data into your apps and use a rich set of cognitive services to build human-like intelligence across any scale of data. AI is native to the data platform—you can unlock insights faster from all your data, on-premises and in the cloud. Combine your unique enterprise data and the world's data to build an intelligence-driven organization. Work with a flexible data platform that gives you a consistent experience across platforms and gets your innovations to market faster—you can build your apps and then deploy anywhere.
|
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
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
|
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
Any business and organization seeking a solution to manage their cloud operations
|
Audience
database administrators for Microsoft SQL Server
|
|||||
Support
Phone Support
Not 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
Free
Free Version
Supported
Free Trial
Not 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/
|
|||||
Pros & Cons from Real UsersPros
Cons
|
||||||
Training
Documentation
Supported
Webinars
Not Supported
Live Online
Not Supported
In Person
Supported
|
Training
Documentation
Supported
Webinars
Supported
Live Online
Not Supported
In Person
Not Supported
|
|||||
Company InformationMicrosoft
Founded: 1975
United States
www.microsoft.com/en-us/sql-server/
|
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
Supported
Creation / Development
Supported
Data Migration
Not Supported
Data Replication
Not Supported
Data Search
Not Supported
Data Security
Supported
Database Conversion
Not Supported
Mobile Access
Supported
Monitoring
Not Supported
NOSQL
Supported
Performance Analysis
Not Supported
Queries
Not Supported
Relational Interface
Not Supported
Virtualization
Not Supported
SQL Server Features
CPU Monitoring
Supported
Credential Management
Supported
Database Servers
Supported
Deployment Testing
Supported
Docker Compatible Containers
Supported
Event Logs
Supported
History Tracking
Supported
Patch Management
Supported
Scheduling
Supported
Supports Database Clones
Supported
User Activity Monitoring
Supported
Virtual Machine Monitoring
Supported
Business Intelligence Features
Ad Hoc Reports
Supported
Benchmarking
Supported
Budgeting & Forecasting
Supported
Dashboard
Not Supported
Data Analysis
Supported
Key Performance Indicators
Not Supported
Natural Language Generation (NLG)
Not Supported
Performance Metrics
Supported
Predictive Analytics
Not Supported
Profitability Analysis
Not Supported
Strategic Planning
Not Supported
Trend / Problem Indicators
Not Supported
Visual Analytics
Not Supported
Relational Database Features
ACID Compliance
Supported
Data Failure Recovery
Supported
Multi-Platform
Supported
Referential Integrity
Supported
SQL DDL Support
Supported
SQL DML Support
Supported
System Catalog
Supported
Unicode Support
Supported
|
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
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
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
|
|||||
Integrations
Accura E-Commerce
Supported
Accura Software Financial
Supported
BigBI
Supported
Chat2DB
Supported
Great Expectations
Supported
HeidiSQL
Supported
Itron Enterprise Meter Data Management
Supported
Navicat Data Modeler
Supported
PathSolutions TotalView
Supported
Pipeline Enterprise
Supported
|
Integrations
Accura E-Commerce
Not Supported
Accura Software Financial
Not Supported
BigBI
Not Supported
Chat2DB
Not Supported
Great Expectations
Not Supported
HeidiSQL
Not Supported
Itron Enterprise Meter Data Management
Not Supported
Navicat Data Modeler
Not Supported
PathSolutions TotalView
Not Supported
Pipeline Enterprise
Not Supported
|
|||||
|
|
|