SQL Workload Analysis

SQL Workload Analysis

IDERA, an Idera, Inc. company
+
+

Related Products

  • Google Cloud SQL
    537 Ratings
    Visit Website
  • RaimaDB
    9 Ratings
    Visit Website
  • Site24x7
    835 Ratings
    Visit Website
  • Windocks
    7 Ratings
    Visit Website
  • New Relic
    2,650 Ratings
    Visit Website
  • Google Cloud Platform
    60,421 Ratings
    Visit Website
  • AdRem NetCrunch
    148 Ratings
    Visit Website
  • DbVisualizer
    522 Ratings
    Visit Website
  • MongoDB Atlas
    1,644 Ratings
    Visit Website
  • Grafana
    577 Ratings
    Visit Website

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.

About

Visual Expert is a static code analyzer for Oracle PL/SQL, SQL Server T-SQL, and PowerBuilder. Identify code dependencies to modify your code without breaking your application. Scan your code to improve the security, performance, and quality. Perform Impact analysis to Identify breaking changes. Automatically scan your code to detect and fix security vulnerabilities, bugs and maintenance Issues. Implement continuous code inspection Understand the inner workings of your code with call graphs, code diagrams, CRUD Matrix and Object Dependency Matrix (ODM). Automatically generate an HTML Source Code documentation. Explore your code exploration with hyperlinks Compare applications, databases or pieces of code. Improve maintainability. Clean up code. Comply with dev standards. Analyze and Improve DB code performance: Find slow objects and SQL queries, Optimize a slow object, a Chain of calls a slow SQL, Get a query Execution Plan. And much more.

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

database administrators for Microsoft SQL Server

Audience

Developers

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

$400 per instance
Free Version
Free Trial

Pricing

$495 per year
Free Version
Free Trial

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

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

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

Company Information

Novalys
Founded: 1998
France
www.visual-expert.com

Alternatives

IDERA Precise for Databases

IDERA Precise for Databases

IDERA, an Idera, Inc. company

Alternatives

SonarQube Server

SonarQube Server

SonarSource
SQL Sentry

SQL Sentry

SolarWinds
SonarQube Cloud

SonarQube Cloud

SonarSource
SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company
Embold

Embold

Embold Technologies
SQL Diagnostic Manager for SQL Server

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
CodeSonar

CodeSonar

CodeSecure
SQL Doctor

SQL Doctor

IDERA, an Idera, Inc. company

Categories

Categories

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

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

Application Development Features

Access Controls/Permissions
Code Assistance
Code Refactoring
Collaboration Tools
Compatibility Testing
Data Modeling
Debugging
Deployment Management
Graphical User Interface
Mobile Development
No-Code
Reporting/Analytics
Software Development
Source Control
Testing Management
Version Control
Web App Development

Source Code Management Features

Access Controls/Permissions
Bug Tracking
Build Automation
Change Management
Code Review
Collaboration
Continuous Integration
Repository Management
Version Control

Static Code Analysis Features

Analytics / Reporting
Code Standardization / Validation
Multiple Programming Language Support
Provides Recommendations
Standard Security/Industry Libraries
Vulnerability Management

Vulnerability Management Features

Asset Discovery
Asset Tagging
Network Scanning
Patch Management
Policy Management
Prioritization
Risk Management
Vulnerability Assessment
Web Scanning

Integrations

SQL Server
Amazon EC2
Apache Subversion
Azure DevOps Server
Azure Virtual Machines
Git
GitHub
GitLab
Jenkins
Oracle Database
PowerBuilder
Visual Studio

Integrations

SQL Server
Amazon EC2
Apache Subversion
Azure DevOps Server
Azure Virtual Machines
Git
GitHub
GitLab
Jenkins
Oracle Database
PowerBuilder
Visual Studio
Claim SQL Workload Analysis and update features and information
Claim SQL Workload Analysis and update features and information
Claim Visual Expert and update features and information
Claim Visual Expert and update features and information