Page History

Monitoring Datasets

When monitoring the Dataset module, you will be monitoring monitor the bahavior behavior of connected DBs. The To execute the monitoring, you will use 3 three methods to ensure the Database is connected you have data access:

• Is Started: Check if your Database is running.
• Query Execution Time:

• Evaluate the

• Query response time.
• Connection String: Verifies if the

• Database is correctly configured.

Is Started

This property indicates if the Dataset is initialized and connected to the databaseDatabase. You can use it to check if the dataset Dataset is currently running. The code block below shows an example of how to execute executing this method using Scripts.

bool isStarted = @Dataset.DB.YourDatabaseName.IsStarted;

Note that the returning value is a boolean. If the received value is true, the Database is initialized and connected.

Query Execution Time

You can measure the execution time of a query by checking the time before and after executing the query. See the example The code below:block below shows an example of executing this method using Scripts.

DateTime startTime = DateTime.Now; 
@Dataset.Query.YourQueryName.SelectCommand(); 
DateTime endTime = DateTime.Now; 
TimeSpan executionTime = endTime - startTime;

The total execution time will be available on the executionTime variable.

Connection String

You can check the connection string used for the database to ensure it is configured correctly. See Use the example code below:available below to execute this monitoring method.

string connectionString = @Dataset.DB.YourDatabaseName.ConnectionString;

In this section...