Windows SQL server database monitoring software for SQL server versions 2005, 2008, 2012 & 2014, designed to scan, alert, and investigate SQL server failures, and performance issues. DIAB is an innovative, reliable, and cutting-edge product for DBA's, built to be a quick-response product for solving problems when they occur and easing the burden of everyday tasks. DIAB works from a single machine to monitor all your SQL servers. It alerts you when a SQL server instance or agent is down, when drives or database files are about to reach max capacity, informs you when record blocking is occurring, alerts when permissions have been altered, notifies you when backups have failed, and alerts when scheduled jobs have failed. DIAB's powerful historical performance and query analysis tools allow you to chart a course for future expansion, and identify queries consuming resources at any time in the past. DIAB's real-time problem solving tools quickly identify queries eating up resources and give detailed information on problem queries. DIAB can instantly start a trace on a spid, user, or application so you can quickly identify where a process may be failing. DIAB can kill problem processes instantly. DIAB delivers real-time 3D results of hardware resources being consumed, including CPU, disk usage, memory utilization, and network activity. DIAB delivers real-time results of SQL server processing loads. DIAB helps to resolve data warehouse problems by monitoring your OLAP cube processes. DIAB's SOX tools monitor server security and alerts when permission changes occur. DIAB contains an assortment of tools for improving SQL server performance that you can use to optimize your indexes and queries, and do disk load-balancing. DIAB's search tool will locate object references on the server. Email alerts can notify you of server failures. DIAB's SQL code analysis will scan SQL scripts and recommend changes based on SQL best practices, found table scans and missing indexes.
What is new in this release:
- Improved setup wizard.
- Now runs as a background service.
- New alerts to detect fragmentation and slow disk performance.
What is new in version 18.104.22.168:
- New setup wizard.
- SQL query editor for managing and creating your favorite queries.
- MySQL which allows you to include your own personalized queries in DIAB as a menu item.