SQL Workload Analysis

SQL Workload Analysis

IDERA, an Idera, Inc. company

About

MyDefrag is a free defragmentation program for all Windows systems starting from Windows 2000. MyDefragGUI is the graphical user interface for the comfortable handling of this program. MyDefrag defragments very fast, has several optimization strategies, offers the highest possible data security, and can also defragment external storage media. However, you can input options only by a script grammar. With MyDefragGUI the operation becomes very easy. Beyond that, it has some additional functions e.g. planning the defragmentation, storing the personal settings, and configuring the screensaver. Runs under Windows 2000/XP/Server 2003/MCE/Vista/X64/Server 2008/7. MyDefrag has to scan all the files on the disk to determine if they are fragmented and where they are. At the moment it has to use very inefficient Microsoft function calls, in the future I hope to speed this up by directly reading the MFT and FAT.

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

ThinkSQL is a powerful, cross-platform relational database management system designed for modern operating systems and hardware. It aims to comply fully with the ISO SQL standard to provide an open and flexible SQL server for your applications. Compliance with the SQL standard means it supports transactions, sub-selects, views, set operators (union, except, intersect), access privileges and comprehensive referential constraints to ensure the integrity of your data. ThinkSQL uses a multi-versioning engine to provide consistent views of data and concurrent access to rows without locking. The server also has stored procedures and functions (using the standard syntax), and has support for large multimedia objects. It's easy to install, runs on Windows ® and Linux ®, and has native ODBC, JDBC™, dbExpress™ and Python drivers so your applications can connect directly from any platform.

About

Specifically designed to defragment single files or entire folders without the need to defragment the whole disk. WinContig is an easy-to-use stand-alone defragmentation tool that doesn't create any installation directories or Registry entries on your computer. Its purpose is to quickly defragment files without the need to defragment the whole disk. WinContig supports FAT32 and NTFS file systems and it works with Hard Disks and SSDs. Most defragmentation programs perform general defragmentation of an entire partition. In a real-life scenario, you often want to defragment a single file or a directory, for example, to improve the loading speed of a program file, or to reduce the loading time of a certain disk-intensive application like a game. WinContig has been designed specifically to meet the needs of users who focus mainly on files and folders rather than an entire disk. Its ability to filter files by several criteria.

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

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

Anyone seeking a solution to scan files in order to defragment them and optimize performance

Audience

database administrators for Microsoft SQL Server

Audience

Companies searching for a solution to manage and improve their database operations

Audience

Professional users and anyone seeking a tool to defragment single files or entire folders

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

API

Offers API

API

Offers API

API

Offers API

API

Offers API

Screenshots and Videos

Screenshots and Videos

Screenshots and Videos

Screenshots and Videos

Pricing

Free
Free Version
Free Trial

Pricing

$400 per instance
Free Version
Free Trial

Pricing

No information available.
Free Version
Free Trial

Pricing

Free
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

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

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Company Information

MyDefrag
United Kingdom
www.mydefrag.net

Company Information

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

Company Information

ThinkSQL
United Kingdom
www.thinksql.co.uk

Company Information

WinContig
www.mdtzone.it/sw/wincontig/en/index.html

Alternatives

Alternatives

SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company

Alternatives

Alternatives

IDERA Precise for Databases

IDERA Precise for Databases

IDERA, an Idera, Inc. company
CA Datacom

CA Datacom

Broadcom
Puran Registry Defrag

Puran Registry Defrag

Puran Software
SQL Sentry

SQL Sentry

SolarWinds
Tibero

Tibero

TmaxSoft
SQL Diagnostic Manager for SQL Server

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
Puran Defrag

Puran Defrag

Puran Software
UltimateDefrag

UltimateDefrag

Disktrix
SQL Doctor

SQL Doctor

IDERA, an Idera, Inc. company
Huawei RDS

Huawei RDS

Huawei Cloud

Categories

Categories

Categories

Categories

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

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

RDBMS Features

Backup
Data Migration
Monitoring
Performance Analysis
Queries
Storage Optimization

Integrations

Amazon EC2
Azure Virtual Machines
SQL Server

Integrations

Amazon EC2
Azure Virtual Machines
SQL Server

Integrations

Amazon EC2
Azure Virtual Machines
SQL Server

Integrations

Amazon EC2
Azure Virtual Machines
SQL Server
Claim MyDefrag and update features and information
Claim MyDefrag and update features and information
Claim SQL Workload Analysis and update features and information
Claim SQL Workload Analysis and update features and information
Claim ThinkSQL and update features and information
Claim ThinkSQL and update features and information
Claim WinContig and update features and information
Claim WinContig and update features and information