List of topics tagged "databases"

How to use modern MS SQL driver?


Q: Which driver should I use to monitor MS SQL servers? A: MS SQL database monitor runs SQL queries against Microsoft SQL Server. To do that, IPHost Network Monitor can use one of the following drivers: SQLOLEDB (deprecated) – Microsoft OLE DB Provider for SQL Server, or MSOLEDBSQL – Microsoft OLE DB Driver for SQL […]

How do I monitor MS SQL server with non-default instance?


Q: I can’t figure out how to monitor non-default instance of MS SQL server. Can you help? A: We recommend using Microsoft SQL Database Server application template as a base and then accommodate its monitors’ settings to use your non-default MSSQL instance. Follow the steps described below to achieve it: 1. Click button to start […]

How to monitor Oracle database?


How do I monitor my Oracle databases? Q: I can’t figure out how to create monitor for Oracle database(s). Can you help? A: Add and configure the Oracle DB monitor like in the example below: Use your database name and user credentials, specify an SQL request that returns an integer value. Let’s check several typical […]

How to specify database name for Oracle DB monitor?


How should I specify database name for Oracle DB monitor? Q: What shall I enter into “Oracle Database Name” field when creating Oracle DB monitor? Alias from tnsnames.ora, server name (IP address) or service name (TRAD11P_PROD)? A: “Oracle Database Name” is database instance name. Oracle database monitor type doesn’t make use of TNS. Note: it […]

How to configure MySQL DB monitor?


How should I configure MySQL DB monitor? Q: How to configure MySQL DB monitor? A: Starting from v5.1 build 13063, IPHost Network Monitor doesn’t require explicit downloading and installing MySQL client DLL. In the monitor’s “Main Parameters” tab specify SQL request that returns an integer value specify database name enter TCP port value if different […]