Database server monitors

Unless you’re serving up a static brochure website, your website or web service depends on a database to retrieve content, manage users, or process orders. Knowing your database response times can help you avoid catastrophe. Using Uptrends' database server monitors, you can always know when your database is in trouble.

Uptrends will use its 233 checkpoints to monitor your database server externally.

How does database monitoring work?

With Uptrends' database monitoring, you can monitor Microsoft SQL Server or MySQL. The Uptrends checkpoints will attempt to establish a connection to the IP address and database you specify on the Advanced tab, and if you provide login credentials, the checkpoint will attempt a successful login. Besides the response times you specify on the Error conditions tab, Uptrends will trigger an alert for failed or lost connections.

A database monitor type will send you alerts based on response time and connectivity issues. You will find the database server monitor setup similar to setting up an HTTPS monitor type with just a couple special fields. For information about setting up monitors and error conditions, visit the knowledge base. For a database monitor you will need to know:

• Database name
• Database URL or IP
• Database login credentials (if needed)

Setting up a database monitor

To set up a database monitor

1. Click the + button in the menu Monitoring > Monitor setup.
2. Select either Microsoft SQL Server or MySQL under Database Servers in the Type box.
3. Type the domain name or IP address for the database server in the Network Address box.
4. Complete the other fields on the Main tab.
5. Set your expected response times on the Error conditions tab.
6. Click the Advanced tab.
7. Provide a Username and Password if necessary.
8. Provide the Database name.
9. Choose your checkpoints on the Checkpoints tab.
10. Click Save.