MONyog

The Internet quickly gained ground and is now available across the world greatly enhancing data transfer and communication. Information is usually well kept within servers which need to be constantly monitored to prevent unauthorized access and other issues. As such, MONyog comes with powerful monitoring tools for multiple SQL servers.

The application doesn’t necessarily have to be installed on a host SQL server, but you do need to make sure that the computer it’s used on is fitted with Microsoft SQL Server to be able to establish the connection.

Once services are configured you’re redirected to the administration account. This, as well as all other operations are performed in an online interface, so you team up with your preferred web browser for this task.

Needless to say that one of the first operations is to configure a server to monitor. Several detail fields need to be filled in, such as host name and port, credentials, connection type, whether or not to enable SSH connection for more safety, notifications over email or SNMP, as well as a set of advanced options like data collection, replication, error and query logs, sniffer, deadlock, monitors, and real-time tracking.

You’re free to add multiple servers, and these settings need to be configured for each new entry. A side panel enlists all added items, with the possibility to select specific ones to monitor.

Although pretty well-organized by default, the set of values shown and tools you use can be customized. These settings refer to email, SNMP, and LDAP settings, ports, users, passwords, reports, maintenance, or information fields to display on monitors, charts, and how to handle changes.

Monitoring starts right away if a target server is selected from the list. A great deal of information is provided and structured in tabs like monitors, real-time, query analyzer, process list, charts, replication, disk info, or events.

Server configuration commands can be issued, with a rich list of presets to help out. Notifications can come in real time either in the interface or via email. Data is displayed in great deal, and most sections expand on mouseover with a full description of functionality.

To sum it up, MONyog is sure to provide the necessary tools to keep multiple SQL servers under control. Server setup is intuitive, and notifications can be received through a couple of different methods. The online interface can be customized, while the level of details provided is cleverly organized in dedicated sections.