IDERA, Inc.

This software provides a clear graphical display of fragmentation levels, index types, sizes, and fill factors across SQL servers. This allows users to quickly identify areas that require attention.

This software locates sensitive data by scanning through an entire instance or selected tables. It offers 45 pre-configured search strings and allows users to export results into CSV format for analysis and reporting.

A management console software allows easy viewing of past and current jobs, identifying and correcting contention, drag and drop jobs for leveled workloads, providing a glance view of failed or runaway jobs, and a customizable calendar view.

Software generates T-SQL scripts for copying & editing user permissions, executing them accordingly. Includes object-level permissions for selected databases. Four steps to copy, extract, modify, and apply changes.

Analyze query performance with a tool that monitors high-resource consumption. Use execution statistics and explain plans to fine-tune queries, and manually evaluate results within the software. Easily export results in different formats for convenient analysis and reporting.

Track CPU and memory consumption of Windows processes with the ability to focus in on specific sibling processes. Efficiently determine the most resource-consuming processes with a convenient heat map display, quickly resolving any identified issues.

Track running sessions and their SQL statements in a simple and intuitive software. Organize and export events for easy sharing and analysis. Start and execute in two quick clicks, and group and sort events to quickly identify necessary information.

An efficient software tool for real-time monitoring of physical server metrics and analyzing metrics for SSAS processing, memory, and cache of SQL Server Analysis Services. With a setup time of a few minutes, the tool does not require any agents.