+
+

Related Products

  • AdRem NetCrunch
    158 Ratings
    Visit Website
  • RaimaDB
    12 Ratings
    Visit Website
  • Google Cloud SQL
    553 Ratings
    Visit Website
  • Teradata VantageCloud
    1,122 Ratings
    Visit Website
  • Grafana Cloud
    853 Ratings
    Visit Website
  • New Relic
    2,923 Ratings
    Visit Website
  • Windocks
    7 Ratings
    Visit Website
  • DbVisualizer
    583 Ratings
    Visit Website
  • Atera
    2,094 Ratings
    Visit Website
  • Google Cloud Platform
    61,012 Ratings
    Visit Website

About

Quickly pinpoint performance issues with SolarWinds® Database Performance Analyzer (DPA) while providing expert advice with tuning advisors. Anomaly detection powered by machine learning allows DBAs to proactively optimize databases before small issues become big problems. Real-time analysis with 24/7 monitoring and automated alerts provides the time an error occurred instead of just knowing it was “sometime last week.” DPA helps ease the use of more than 20 cross-platform databases in hybrid, on-premises and cloud environments.

About

PawSQL integrates the best practices of query optimization in database industry, provides advanced SQL rewrite optimization, and sophisticate index recommendation capabilities for slow queries. Based on the professional PawSQL optimization engine (used by more than 10,000 database practitioners around the world), it provides rich SQL optimization suggestions and intelligent index recommendations. PawSQL provides a comprehensive and balanced audit rule set for multiple databases such as MySQL, PostgreSQL, openGauss, Oracle, etc., providing enterprises with a consistent audit experience no matter how diverse their database environment is. Rule-based SQL review, covering potential correctness and performance optimization issues. Rich rewrite optimization, recommending semantically equivalent but more efficient SQL queries. Cost-based verification ensures that new solutions based on SQL rewrite and index recommendation have better performance. Intelligent index recommendation.

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, Database Engineers, System Administrators

Audience

Individuals looking for query optimization in database industry, advanced SQL rewrite optimization, and sophisticate index recommendation capabilities for slow queries

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

No information available.
Free Version
Free Trial

Reviews/Ratings

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

Reviews/Ratings

Overall 5.0 / 5
ease 5.0 / 5
features 5.0 / 5
design 4.0 / 5
support 3.0 / 5

Pros & Cons from Real Users

Pros

  • - Does way more than just a reporting tool. A really in-depth analysis of every storage element is provided in the plethora of high-quality reports.
  • You can monitor and analyze every type of DB from its productive monitoring feature. Automation management API is very useful. It makes it easy to identify performance. Gives you optimizer suggestion.

Cons

  • Not very useful for light/small databases as the tool itself can be quite heavy.
  • Not a single cons. It worked perfectly for me.

Pros & Cons from Real Users

Pros

  • 1. Comprehensive Database Support: PawSQL supports a variety of database systems, including MySQL, PostgreSQL, OpenGauss, and more, providing a consistent auditing experience across diverse database environments 2. Advanced Parsing Capabilities: PawSQL demonstrates excellent parsing abilities, capable of handling all tested SQL statements without issues 3. High-Accuracy Warnings: PawSQL provides SQL warnings or tips with high precision, focusing not only on the correctness of SQL statements but also offering performance optimization rules and potential correctness issues 4. Optimization Suggestions: PawSQL offers query rewrite optimization and intelligent index recommendations, helping developers and DBAs solve SQL performance issues in a one-stop manner 5. Performance Verification: PawSQL provides a What-If performance verification feature, offering an analyze option to obtain the actual parsing and execution cost of SQL, avoiding the shortcomings of MySQL's explain for intermediate result tables and providing more accurate cost estimation

Cons

  • PawSQL doesn't support SQL Server yet, and little support for HIVE SQL.

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Company Information

SolarWinds
Founded: 2000
United States
www.solarwinds.com

Company Information

PawSQL
Founded: 2024
China
www.pawsql.com

Alternatives

Alternatives

Foglight

Foglight

Quest Software
Monitorpack Guard

Monitorpack Guard

Monitorpack
DB Optimizer

DB Optimizer

IDERA, an Idera, Inc. company
SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company
SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company

Categories

Categories

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 Performance Monitoring (APM) Features

Baseline Manager
Diagnostic Tools
Full Transaction Diagnostics
Performance Control
Resource Management
Root-Cause Diagnosis
Server Performance
Trace Individual Transactions

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

IT Management Features

Capacity Monitoring
Compliance Management
Event Logs
Hardware Inventory
IT Budgeting
License Management
Patch Management
Remote Access
Scheduling
Software Inventory
User Activity Monitoring

RDBMS Features

Backup
Data Migration
Monitoring
Performance Analysis
Queries
Storage Optimization

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

DataGrip
Datto Workplace
HCL BigFix AEX
MariaDB
Microsoft Azure
MySQL
Oracle Database
Pliant
PostgreSQL
Signal9
SolarWinds Observability SaaS
SolarWinds Observability Self-Hosted

Integrations

DataGrip
Datto Workplace
HCL BigFix AEX
MariaDB
Microsoft Azure
MySQL
Oracle Database
Pliant
PostgreSQL
Signal9
SolarWinds Observability SaaS
SolarWinds Observability Self-Hosted
Claim SolarWinds Database Performance Analyzer and update features and information
Claim SolarWinds Database Performance Analyzer and update features and information
Claim PawSQL and update features and information
Claim PawSQL and update features and information