Overview
Monitoring Database Connections is essential to maintaining a reliable and efficient system. By keeping the Dataset module you keep track of Database Connections , you can to ensure your data is accessed and updated correctly. This page will present the methods used to maintain an efficient platform.
On this page:
Table of Contents | ||
---|---|---|
|
Monitoring
Databases ConnectionsDatasets
When monitoring the Dataset module, you will be monitoring the bahavior of connected DBs. The execute the monitoring, you will use 3 methods to ensure the Database is connected you have There are 3 used methods to ensure correct data access:
Is Started: Check if your Database is running.
Query Execution Time: Evaluates the Queries reponse time.
Connection String: Verifies if the Dabase is connected.
Each one of these methods are describe See each one of them in more detail in the sections belownext.
Is Started
This property indicates if the Dataset is initialized and connected to the database. You can use it to check if the dataset is currently running, see the example code below:. The code block below shows an example of how to execute this method using Scripts.
Code Block | ||||
---|---|---|---|---|
| ||||
bool isStarted = @Dataset.DB.YourDatabaseName.IsStarted; |
Note that the returning value is a boolean. If the received value is true
,
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 code below:
Code Block | ||||
---|---|---|---|---|
| ||||
DateTime startTime = DateTime.Now; @Dataset.Query.YourQueryName.SelectCommand(); DateTime endTime = DateTime.Now; TimeSpan executionTime = endTime - startTime; |
Connection String
You can check the connection string used for the database to ensure it is configured correctly. See the example code below:
Code Block | ||||
---|---|---|---|---|
| ||||
string connectionString = @Dataset.DB.YourDatabaseName.ConnectionString; |
Note |
---|
Please note that these are just examples, and you will need to replace |
In this section...
Page Tree | ||||
---|---|---|---|---|
|