Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
Monitor and diagnose database wait states and transaction details. SQL Server's performance and the business-critical applications it supports can be severely affected by problematic SQL queries. The SQL Workload Analysis addon allows you to continuously monitor and analyze server load. It also provides a simple user interface that focuses only on application performance and wait states. You can also troubleshoot SQL code changes to database applications. Continuous SQL sampling intervals allow you to perform real-time analysis. Instantly see where databases are spending their time. Quickly identify slow SQL statements and drill down to get actionable advice. Investigate historical query plan trends. Automated recommendations can be used to improve query performance.
Description
Visual Expert is a static code analyzer for Oracle PL/SQL, SQL Server T-SQL and PowerBuilder.
It identifies code dependencies to let you modify the code without breaking your application.
It also scans your code to detect security flaws, quality, performance and maintenability issues.
Identify breaking changes with impact analysis.
Scan the code to find security vulnerabilities, bugs and maintenance issues.
Integrate continuous code inspection in a CI workflow.
Understand the inner workings and document your code with call graphs, code diagrams, CRUD matrices, and object dependency matrices (ODMs).
Automatically generate source code documentation in HTML format.
Navigate your code with hyperlinks.
Compare two pieces of code, databases or entire applications.
Improve maintainability. Clean up code. Comply with development standards.
Analyze and improve database code performance: Find slow objects and SQL queries, optimize a slow object, a call chain, a slow SQL query, display a query execution plan.
API Access
Has API
No
API Access
Has API
No
Integrations
SQL Server
Yes
Amazon EC2
Yes
Apache Subversion
No
Azure DevOps Server
No
Azure Virtual Machines
Yes
Git
No
GitHub
No
GitLab
No
Jenkins
No
Oracle Database
No
Integrations
SQL Server
Yes
Amazon EC2
No
Apache Subversion
Yes
Azure DevOps Server
Yes
Azure Virtual Machines
No
Git
Yes
GitHub
Yes
GitLab
Yes
Jenkins
Yes
Oracle Database
Yes
Pricing Details
$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 Trial
Yes
Free Version
No
Pricing Details
$495 per year
Perpetual license available
Floatting license available
Floatting license available
Free Trial
Yes
Free Version
No
Deployment
Web-Based
No
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
Yes
Mac
No
Linux
No
Chromebook
No
Deployment
Web-Based
No
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
Yes
Mac
No
Linux
No
Chromebook
No
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
Yes
Live Training (Online)
No
In Person
No
Types of Training
Training Docs
Yes
Webinars
Yes
Live Training (Online)
Yes
In Person
No
Vendor Details
Company Name
IDERA, an Idera, Inc. company
Founded
2004
Country
United States of America
Website
www.idera.com/productssolutions/sqlserver/sql-workload-analysis
Vendor Details
Company Name
Novalys
Founded
1998
Country
France
Website
www.visual-expert.com
Product Features
Database
Backup and Recovery
No
Creation / Development
No
Data Migration
No
Data Replication
No
Data Search
No
Data Security
No
Database Conversion
No
Mobile Access
No
Monitoring
Yes
NOSQL
No
Performance Analysis
Yes
Queries
Yes
Relational Interface
No
Virtualization
No
Database Monitoring
Anomaly Detection
Yes
Autodiscovery
No
Capacity Planning
Yes
Dashboard
Yes
Dependency Tracking
No
Historical Trend Analysis
Yes
Multitenancy
No
Notifications / Alerts
Yes
Performance Monitoring
Yes
Permissions / Access Controls
No
Predictive Analytics
No
Prioritization
No
Query Analysis
Yes
Resource Optimization
Yes
Troubleshooting
Yes
SQL Server
CPU Monitoring
Yes
Credential Management
No
Database Servers
No
Deployment Testing
No
Docker Compatible Containers
No
Event Logs
No
History Tracking
Yes
Patch Management
No
Scheduling
No
Supports Database Clones
No
User Activity Monitoring
Yes
Virtual Machine Monitoring
No
Product Features
Application Development
Access Controls/Permissions
No
Code Assistance
No
Code Refactoring
Yes
Collaboration Tools
Yes
Compatibility Testing
No
Data Modeling
No
Debugging
No
Deployment Management
No
Graphical User Interface
No
Mobile Development
No
No-Code
No
Reporting/Analytics
Yes
Software Development
Yes
Source Control
No
Testing Management
No
Version Control
No
Web App Development
No
Performance Testing
API Testing
No
Benchmarking
No
Cross Browser Testing
No
Debugging
No
Historical Reporting
No
Load Testing
No
Mobile Testing
No
Parallel Testing
No
Regression Testing
No
UI Testing
No
Web Testing
No
Source Code Management
Access Controls/Permissions
No
Bug Tracking
No
Build Automation
No
Change Management
Yes
Code Review
Yes
Collaboration
No
Continuous Integration
Yes
Repository Management
No
Version Control
No
SQL Server
CPU Monitoring
No
Credential Management
No
Database Servers
No
Deployment Testing
No
Docker Compatible Containers
No
Event Logs
No
History Tracking
No
Patch Management
No
Scheduling
No
Supports Database Clones
No
User Activity Monitoring
No
Virtual Machine Monitoring
No
Static Application Security Testing (SAST)
Application Security
No
Dashboard
No
Debugging
No
Deployment Management
No
IDE
No
Multi-Language Scanning
No
Real-Time Analytics
No
Source Code Scanning
No
Vulnerability Scanning
No
Static Code Analysis
Analytics / Reporting
Yes
Code Standardization / Validation
Yes
Multiple Programming Language Support
Yes
Provides Recommendations
Yes
Standard Security/Industry Libraries
Yes
Vulnerability Management
Yes
Vulnerability Management
Asset Discovery
No
Asset Tagging
No
Network Scanning
No
Patch Management
No
Policy Management
No
Prioritization
No
Risk Management
No
Vulnerability Assessment
Yes
Web Scanning
No