Select Page

Configure Historic Database Connection

When setting up historic monitoring, Database Health Reports uses a database called DBHealthHistory on the SQL Server that you specify as the monitoring server.  Step 1 is to establish a connection to the server that will hold the monitoring database. Step 2 is to tell the monitoring database which databases to monitor. Once those two steps are complete you then just wait for historic data to be collected.

Step 1: Create or connect to an existing monitoring instance.

When you have not yet configured any historic reporting, the database overview and server overview pages will show the following panel.  This is an indication that there is reporting available that hasn’t yet been turned on.

HistoricConnectionUnconfigured

Click the “Click here to configure…. ” message and the following dialog will be shown to allow you to set up the historic monitoring instance.

HistoricConnection-Step1

When you click the “Connect to or Create a Monitoring Instance” button you will be prompted for database connection credentials. These credentials can be either Windows Authentication or SQL Server authentication. This connection will be used to connect to the database instance and create a database called DBHealthHistory. This database will be used to track the historic data over time for your reports.

When setting up a monitoring instance it is best to use a SQL Server besides the one being monitored. This was the historic tracking data will have less of an impact on your production server. The historic monitoring database will not work with a SQL Express database because the SQL Agent is needed to do the monitoring, and there is no SQL Agent with SQL Express.

HistoricConnection-Step1a

Once you have entered your credentials and the DBHealthHistory database has been created you will see the following message on the configure dialog stating that the “Monitoring instance is configured”.

HistoricConnection-Step2

At this point you are ready to specify which databases are going to be monitored.

Step 2: Set the credentials to use for monitoring.

The second step is to set up the credentials that will be used to monitor any database. If you see the following dialog, you know you are ready to go on to step 2.

HistoricConnection-Step2

You will be prompted for credentials to use for monitoring. Here SQL Server authentication is the only supported option. Specify a SQL Server username and password that will be used when connecting from the monitoring server to the server that is being monitored.

HistoricConnection-Step2Credentials

After entering the SQL Server Authentication credentials you will see the “Credentials configured for monitoring” message. Click OK, monitoring will now begin.

HistoricConnection-Step2Complete

Test Your Connection

Once the connection has been set up it usually takes about 4 to 5 minutes before the monitoring begins. You can use the “Test Connection button” to confirm that everything is in place to monitor from one SQL Server to another.

HistoricConnectionComplete

Wait for data to collect over time.

Depending on the load of your SQL Server you may see the following message for some time. For a busy SQL Server, you will usually see reporting data available within a couple hours of when the reporting was turned on. For a lighter load SQL Server it may take a couple days to a week to see any significant wait data.

HistoricConnectionComplete

4 Comments

  1. Fred Botts

    Works great with the exception of the ‘configure historic database’.
    Sometimes it works, and sometimes I have to close and restart the application multiple times to get it to work.

    Reply
  2. Bill Hughes

    Great feature, but I accidentally configured a server twice. How can I remove these?

    Reply
    • Steve Stedman

      If you are referring to configuring the historic monitoring twice, you can check the [instanceMonitor] table in the [DBHealthHistory] database. If there is more than one entry for your server you can just delete one of the rows from that table.

      If you are referring to connecting twice in the main application, you can just right click on the database name, and choose “disconnect”.

      Let me know if this helps.

      Reply
  3. Dany Van den Steen

    What rights need this account ?

    Specify a SQL Server username and password that will be used when connecting from the monitoring server to the server that is being monitored.

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

To prove you are not a robot: * Time limit is exhausted. Please reload CAPTCHA.