IDERA SQL Check is a compact, agentless, real-time diagnostic utility that functions like a heart-rate monitor for your database server. It provides database administrators (DBAs) and systems engineers with a single-screen dashboard to view active performance spikes. Core Performance Metrics Tracked
The platform relies on an intuitive graphical user interface to aggregate live performance streams directly from your server. It continuously visualizes critical operations across four distinct categories:
Throughput and Transactions: Monitors batch requests, active transactions, compilations, and recompilations to track workload volume.
System Wait Stats: Highlights execution bottlenecks, detailing exactly where active queries are stalled or delayed.
Physical Disk I/O: Measures real-time read and write metrics to pinpoint disk-subsystem saturation.
Memory & Cache Performance: Tracks cache hit ratios to confirm how effectively SQL Server uses available RAM. Key Product Features Real-Time Dashboard
The dashboard uses active visual components to reflect ongoing system status. Users can hover their cursor over performance spikes to immediately view granular, raw system details. Zero-Agent Footprint
The utility connects remotely via standard network pathways. Because it does not run local software agents on the monitored instance, it avoids consuming critical production server resources. Flexible Refresh Intervals
Administrators can customize both the metrics refresh cycle and the timeline window. This configuration makes it an ideal fit for dedicated, low-overhead monitoring screens on NOC team LCD displays. Initial Setup and Prerequisites
Deployment can be completed rapidly via standard Windows configuration tools. The installation process involves the following basic steps:
Run the Installer: Execute the lightweight setup file using the standard deployment wizard.
Verify Network Sight: Confirm your local machine can discover the destination database asset by running a standard network ping: ping YOUR_SERVER_NAME Use code with caution.
Audit Remote Performance Counters: Verify that your current Windows execution account has permissions to access the remote system counters. You can validate this connection within the native Windows Performance Monitor (perfmon) by attempting to load the remote SQLServer:General Statistics counter group.
Register the Instance: Open the application, insert your target instance connection string, and begin viewing the live diagnostic charts. Alternative Monitoring Options
Depending on your production environment constraints, you may want to consider other monitoring paths:
IDERA SQL Diagnostic Manager: If you outgrow the basic tool, IDERA offers SQL Diagnostic Manager via a fully functional 14-day evaluation trial. This version includes predictive alerting, historical query logging, and dedicated cloud VM tracking.
SSMS Activity Monitor: For a completely native approach, open SQL Server Management Studio (SSMS), right-click your instance, and launch the built-in Activity Monitor. This tool displays active expensive queries, process lists, and disk I/O metrics at zero extra cost.
To help find the right monitoring fit for your environment, consider the following details:
Are you looking to display this data on a live dashboard monitor, or do you need automated email alerts when thresholds are breached?
How many distinct SQL Server instances do you need to watch simultaneously? Free Tool – SQL Check | IDERA Database Tools
Leave a Reply