SQL Workload Analysis

SQL Workload Analysis

IDERA, an Idera, Inc. company
+
+

Related Products

  • AdRem NetCrunch
    165 Ratings
    Visit Website
  • Grafana Cloud
    860 Ratings
    Visit Website
  • Overmonitor
    8 Ratings
    Visit Website
  • Uptime.com
    479 Ratings
    Visit Website
  • PathSolutions TotalView
    43 Ratings
    Visit Website
  • New Relic
    2,938 Ratings
    Visit Website
  • NinjaOne
    6,035 Ratings
    Visit Website
  • Auvik
    675 Ratings
    Visit Website
  • ManageEngine Log360
    190 Ratings
    Visit Website
  • SuperOps
    223 Ratings
    Visit Website

About

Checkmk is a comprehensive IT monitoring system that enables system administrators, IT managers, and DevOps teams to identify issues across their entire IT infrastructure (servers, applications, networks, storage, databases, containers) and act quickly to resolve them More than 2,000 commercial customers and many more open source users worldwide use Checkmk daily. Key product features: • Service state monitoring with almost 2,000 checks 'out of the box' • Log and event-based monitoring • Metrics, dynamic graphing, and long-term storage • Comprehensive reporting incl. availability and SLAs • Flexible notifications and automated alert handling • Monitoring of business processes and complex systems • Hardware and software inventory • Graphical, rule-based configuration, and automated service discovery Top use cases: • Server Monitoring • Network Monitoring • Application Monitoring • Database Monitoring • Storage Monitoring • Cloud Monitoring • Container Monitoring

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 Supported
Cloud 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

System administrators, IT managers and DevOps

Audience

database administrators for Microsoft SQL Server

Support

Phone Support Supported
24/7 Live Support Not 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

$0/year
Pricing is per service i.e. per monitored metric such as CPU utilization
Free Version 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/Ratings

Overall 4.5 / 5
ease 5.0 / 5
features 5.0 / 5
design 4.0 / 5
support 5.0 / 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

Pros & Cons from Real Users

Pros

  • -The user interface and graphical user interface are straightforward and easy to use, updates are effortless to implement. -It can easily monitor city platforms, databases, servers, etc. -You can customize the notification, being based on Nagios, it is mighty and swift to use.
  • It's the best IT monitoring solution. It can monitor cloud, server and database flawlessly. It monitors core performance and resources. Very easy to deploy and check Azure cloud performance.

Cons

  • -The front-end design is a bit outdated and can be improved for the user's better experience. Other than that, everything works fine and effortless.
  • Overall it's an outstanding IT monitoring solution.

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 Information

Checkmk
Founded: 2007
Germany
checkmk.com

Company Information

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

Alternatives

AdRem NetCrunch

AdRem NetCrunch

AdRem Software

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
I&B monitoring

I&B monitoring

INB Monitoring FZCO
SQL Sentry

SQL Sentry

SolarWinds
Sematext Cloud

Sematext Cloud

Sematext Group
SQL Diagnostic Manager for SQL Server

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company

Categories

Categories

Database Supported
SQL Server Supported

Database Monitoring Features

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

Business Activity Monitoring Features

Alerts / Notifications Supported
Business Process Management Supported
Cross Application Analysis Supported
Email Monitoring Supported
Events Monitoring Supported
KPI Monitoring Supported
Pre-Configured Events Supported
Reporting / Analytics Supported
Workflow Management Not Supported

Cloud Management Features

Access Control Not Supported
Billing & Provisioning Not Supported
Capacity Analytics Supported
Cost Management Supported
Demand Monitoring Not Supported
Multi-Cloud Management Supported
Performance Analytics Supported
SLA Management Supported
Supply Monitoring Supported
Workflow Approval Not Supported

Container Security Features

Access Roles / Permissions Supported
Application Performance Tracking Not Supported
Centralized Policy Management Not Supported
Container Stack Scanning Supported
Image Vulnerability Detection Not Supported
Reporting Supported
Testing Supported
View Container Metadata Supported

IT Infrastructure Monitoring Features

Alerts / Notifications Supported
Application Monitoring Supported
Bandwidth Monitoring Supported
Capacity Planning Supported
Configuration Change Management Supported
Data Movement Monitoring Supported
Health Monitoring Supported
Multi-Platform Support Supported
Performance Monitoring Supported
Point-in-Time Visibility Not Supported
Reporting / Analytics Supported
Virtual Machine Monitoring Supported

Network Mapping Features

Color Codes / Icons Not Supported
Compliance Management Not Supported
Device Auto Discovery Supported
Hierarchical Mapping Supported
Location-Based Mapping Supported
Map Exporting Supported
On-Demand Mapping Not Supported
Reporting/Analytics Supported
Self-Updating Maps Supported
Web Traffic Reporting Not Supported

Network Monitoring Features

Bandwidth Monitoring Supported
Baseline Manager Not Supported
Diagnostic Tools Supported
Internet Usage Monitoring Supported
IP Address Monitoring Supported
Real Time Analytics Supported
Resource Management Not Supported
Server Monitoring Supported
SLA Monitoring Supported
Uptime Monitoring Supported
Web Traffic Reporting Supported

Server Management Features

CPU Monitoring Supported
Credential Management Supported
Database Servers Supported
Email Monitoring Supported
Event Logs Supported
History Tracking Supported
Patch Management Supported
Scheduling Not Supported
User Activity Monitoring Not Supported
Virtual Machine Monitoring Supported

System Monitoring Features

Alerts / Notifications Supported
Antivirus Management Not Supported
Data Backup / Recovery Not Supported
Device Monitoring Supported
Inventory Management Supported
Patch Management Not Supported
Policy-based Automation Supported
Remote Monitoring Supported
Reporting / Analytics Supported
Risk Analysis Not Supported
Server Monitoring Supported
Service Configuration Management Supported

Website Monitoring Features

Availability Testing Supported
Event Logs Supported
Event-Based Notifications Supported
FTP Monitoring Supported
Mail Server Monitoring Supported
Maintenance Scheduling Supported
Performance Metrics Supported
Real Time Monitoring Supported
Transaction Monitoring Supported
Uptime Reporting 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

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

Integrations

24Cevent Supported
AWS Backup Supported
Amazon EC2 Not Supported
Aruba Meridian Supported
Bosch IoT Suite Supported
IBM Db2 Supported
IBM Tivoli Monitoring Supported
MongoDB Supported
Oracle Berkeley DB Supported
Plesk Supported
PostgreSQL Supported
SAP HANA Supported
SIGNL4 Supported
SMSEagle Supported
Salesforce Supported
Skype Supported
Sophos Email Supported
openITCOCKPIT Supported
root9 Supported

Integrations

24Cevent Not Supported
AWS Backup Not Supported
Amazon EC2 Supported
Aruba Meridian Not Supported
Bosch IoT Suite Not Supported
IBM Db2 Not Supported
IBM Tivoli Monitoring Not Supported
MongoDB Not Supported
Oracle Berkeley DB Not Supported
Plesk Not Supported
PostgreSQL Not Supported
SAP HANA Not Supported
SIGNL4 Not Supported
SMSEagle Not Supported
Salesforce Not Supported
Skype Not Supported
Sophos Email Not Supported
openITCOCKPIT Not Supported
root9 Not Supported
Claim Checkmk and update features and information
Claim Checkmk and update features and information
Claim SQL Workload Analysis and update features and information
Claim SQL Workload Analysis and update features and information