SQL Server monitoring is quick & easy using the Sentry-go Quick SQL Server Monitor. With it you can easily monitor SQL Servers, as well as your database environment. With it you can check the local Windows Server, SQL Server, databases, ODBC connectivity, queries & locking as well as entries written to the SQL Server log file & local Event Logs.

Monitoring Features

Monitor key services   SQL Server monitoring allows you to monitor key Windows, SQL & database-related services such as MS-DTC, running on the local server out of the box. In addition, custom services can also be added, monitored & automatically restarted. Ensure database connectivity & query results   The database connection monitor option allows you to periodically ensure a connection to your key databases can be made. Optionally, you can also run queries against the connection and verify the results, ideal when you wish to check key database systems are functioning correctly. Monitor Blocked Locking   As part of monitoring SQL Servers, this option allows you to monitor the locks being used by SQL Server - in particular, queries that are being blocked for a given period of time and the queries blocking them. Details can be alerted, logged to a file or both. Verify SQL, database & local server performance SQL Server Performance Monitoring allows you to ensure that key performance parameters are within expected limits - e.g. no. open connections, active transactions, no. table lock escalations etc. Custom performance counters can also be added and monitored. Monitor errors written to the Windows Event Log   Sentry-go allows you to monitor messages written to the Windows Event Logs based on error type, event ID, source or keywords & phrases within the text. Monitor messages written to the SQL Server Log File   By monitoring the SQL Server log file, you can detect lower level database failures and/or internal errors etc. Other custom log files can also be monitored. Monitor messages written to custom log files   In addition to Event Logs, you can also monitor the entries written to text-based log files such as those used for custom applications, based on keywords or phrases within the text.  Ensure sufficient disk space is available   To run efficiently, your Windows server & SQL Server needs adequate free disk space. Sentry-go can check this for you, clearing down temporary files automatically if free space becomes limited.

Respond Automatically or Alert

Quick Monitors allow you to respond in a number of ways, in the event a fault is detected ... Respond automatically by running a command, application, batch file or script Automatically restart a failed Windows Service or reboot the server Alert you via network messaging, standard or custom e-mails Different alerting methods based on day of week and time of day Alert you via the Quick Monitor Console Alert you via your SMS pager gateway provider Interface with external systems via SMTP, HTTP, or scripting Log details to a SysLog Server, database or text file

Web-based Reporting

The built-in web server provides access to the following information direct from your desktop browser ... Standard reports - for recent alerts, current status & performance history Current Database Status - shows the current status of all databases within the SQL Server Current SQL Activity - shows the status of current connections, running queries etc. Current Lock Status - shows the status of the SQL Server locking system, queries, resources etc. Current Transaction Log Status - shows the status of the SQL Server transaction, including longest running query information etc. Recent Blocked Locks - gives details of which queries blocked others. Execute remote SQL statements Interactively - create an interactive SQL session from your web browser.

Example Screenshots

Configuring Database & SQL Query monitoring

Adding a new SQL Connection & Query check /p>

Configuring SDQL Blocked Lock monitoring