Ratings and Reviews 0 Ratings

Total
ease
features
design
support

This software has no reviews. Be the first to write a review.

Write a Review

Ratings and Reviews 0 Ratings

Total
ease
features
design
support

This software has no reviews. Be the first to write a review.

Write a Review

Alternatives to Consider

  • Paessler PRTG Reviews & Ratings
    694 Ratings
    Company Website
  • RaimaDB Reviews & Ratings
    5 Ratings
    Company Website
  • Google Cloud SQL Reviews & Ratings
    510 Ratings
    Company Website
  • Dynatrace Reviews & Ratings
    3,220 Ratings
  • Windocks Reviews & Ratings
    6 Ratings
    Company Website
  • New Relic Reviews & Ratings
    2,556 Ratings
    Company Website
  • Site24x7 Reviews & Ratings
    717 Ratings
    Company Website
  • StarTree Reviews & Ratings
    25 Ratings
    Company Website
  • Google Cloud BigQuery Reviews & Ratings
    1,730 Ratings
    Company Website
  • NMIS Reviews & Ratings
    14 Ratings
    Company Website

What is SQL Query Tuner?

The SQL Query Tuner provides database administrators with tools to analyze and enhance SQL code for SQL Server. It features automated suggestions for SQL tuning and performance improvements, utilizing a color-coded system to evaluate stored routines or entire databases. Additionally, it includes SQL stress load testing to replicate production scenarios with multiple users and executions over designated time frames or cycles. Users can also examine SQL execution and assess performance costs through detailed explain plans, ensuring a comprehensive approach to database optimization. This tool ultimately helps in identifying inefficiencies and enhancing overall database performance.

What is MAISY Database?

The MAISY databases, launched in 1995, initially tracked the energy consumption of 10,000 utility clients in both commercial and residential sectors across the United States. Over the years, these databases have been updated annually, leading to the creation of the 2020 MAISY databases, which now encompass current energy consumption data and hourly load profiles for more than 7 million individual utility customers nationwide. Each entry in these comprehensive databases includes detailed information about the building characteristics, equipment types, operational practices, occupant demographics, and specific energy usage of the utility clients. The development of these hourly load profiles has been supported by a diverse array of data sources, such as utility companies, industry trade groups, governmental statistics, proprietary surveys from Jackson Associates, and thorough engineering evaluations of appliances. These databases not only provide a statistically valid representation of residential and commercial utility consumers across the country but also enhance the reliability and applicability of energy analysis and planning. The breadth of data contained within allows researchers and policymakers to gain deeper insights into energy consumption patterns and trends across various sectors, promoting more effective energy management strategies. Through this ongoing evolution, the MAISY databases continue to serve as vital resources for understanding the complexities of utility energy consumption.

Media

Media

Integrations Supported

Amazon EC2
Azure Virtual Machines
IBM InfoSphere Data Architect
SQL Server

Integrations Supported

Amazon EC2
Azure Virtual Machines
IBM InfoSphere Data Architect
SQL Server

API Availability

Has API

API Availability

Has API

Pricing Information

$400 per instance
Free Trial Offered?
Free Version

Pricing Information

Pricing not provided.
Free Trial Offered?
Free Version

Supported Platforms

SaaS
Android
iPhone
iPad
Windows
Mac
On-Prem
Chromebook
Linux

Supported Platforms

SaaS
Android
iPhone
iPad
Windows
Mac
On-Prem
Chromebook
Linux

Customer Service / Support

Standard Support
24 Hour Support
Web-Based Support

Customer Service / Support

Standard Support
24 Hour Support
Web-Based Support

Training Options

Documentation Hub
Webinars
Online Training
On-Site Training

Training Options

Documentation Hub
Webinars
Online Training
On-Site Training

Company Facts

Organization Name

IDERA, an Idera, Inc. company

Date Founded

2004

Company Location

United States of America

Company Website

www.idera.com/productssolutions/sqlserver/sql-query-tuner

Company Facts

Organization Name

Jackson Associates

Date Founded

1995

Company Location

United States

Company Website

www.maisy.com/maisydatabases.htm

Categories and Features

Database

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

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

SQL Server

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

Categories and Features

Database

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

Popular Alternatives

DB Optimizer Reviews & Ratings

DB Optimizer

IDERA, an Idera, Inc. company

Popular Alternatives

SQL Diagnostic Manager for SQL Server Reviews & Ratings

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
Database X-Ray Reviews & Ratings

Database X-Ray

Murray Hill Technologies
DB PowerStudio Reviews & Ratings

DB PowerStudio

IDERA, an Idera, Inc. company