miniDBA

miniDBA is a database performance analysis and monitoring tool specifically designed for SQL Server. According to the vendor, it caters to businesses of various sizes and is commonly used by professionals such as Database Administrators (DBAs), developers, IT professionals, technology companies, and financial institutions.

Key Features

SQL Server Monitoring: According to the vendor, miniDBA provides real-time monitoring of SQL Server performance and health. It offers over 100 metrics to track connections, CPU, memory, storage, disk latency, and other performance indicators.

Performance Tuning: The vendor states that miniDBA identifies and analyzes slow queries, providing insights on performance bottlenecks. It includes execution plan analysis and allows users to drill down into slow plan operators. Additionally, miniDBA monitors wait statistics and compares them to global averages to identify resource issues.

Health Checks: miniDBA runs server and database health checks to identify configuration and performance issues. The vendor claims that it provides recommendations for optimizing server and database settings. Users can also create customizable T-SQL health checks to address specific needs.

Alerting: According to the vendor, miniDBA offers configurable alerts for various server and database events. Users can choose from multiple notification options, including email, Slack, and Windows Event Log. The tool supports high and low priority alerts with different notification settings.

Faster Troubleshooting: miniDBA provides an enterprise view of the SQL Server estate, allowing users to quickly identify issues. According to the vendor, no code is required to identify and troubleshoot performance problems. The tool also enables historical data analysis for root cause analysis and planning.

Cost-effective: The vendor claims that miniDBA offers competitive pricing starting from $5 per month per SQL or Azure server. It provides an unlimited number of desktop user licenses, and discounts are available for multiple servers.

SQL Server Always On Monitoring: miniDBA monitors the performance and health of Always On databases and replicas. The tool provides metrics for replica performance, database performance, and alerts specific to Always On.

SQL Server Health Checks: miniDBA runs server and database health checks to identify configuration and performance issues. According to the vendor, it provides recommendations based on test results. Users can also create customizable T-SQL health checks to address specific needs.