Overview
Monitoring database connections is crucial for system reliability. Ensure correct data access with these methods:
- IsStarted Property: Check if the dataset is active.
- Query Execution Time: Measure query execution duration.
- ConnectionString: Verify database configuration.
When the solution is running, and the Designer is connected with the runtime, the Datasets Monitor page show basic status server access to tables and queries.
On this page:
| Table of Contents | ||||
|---|---|---|---|---|
|
Datasets Monitor Table
The Datasets Monitor provides a way to monitor real-time information related to the Dataset module operation. The Datasets Monitor is a monitoring-only function, and only will be available when the solution is running, and the Designer is connected with that runtime solution.
The monitoring table will show status of the Server (not clients) operations performed by DatasetTables and DatasetQueries.
The information in this table is constructed from the runtime properties of the DatasetTable and DatasetQuery objects. Additionally of showing in the monitor table, the properties can be accessed on Displays or Scripts, using the following syntax
|
Monitor information | Description |
|---|---|
Name | DatasetTable or DatasetQuery name |
SourceID | Original ID in the DatasetQueries or DatasetTables configuration pages |
RowCount | The total number of rows of data |
Disable | If the object is disabled |
LastStatus | The status value of its last operation (zero success, otherwise error) |
LastStatusMessage | The message corresponding the last error |
In order to embed the monitoring within the application itself, or to get status of Client side commands, see the Dataset Runtime Attributes
In this section:
Monitoring Databases Connections
Monitoring Database Connections is an essential aspect of maintaining a reliable and efficient system within the platform. By keeping track of database connections, you can ensure that your data is being accessed and updated correctly. Here are some ways to monitor database connections:
1. IsStarted: This property indicates if the dataset is started, meaning it has been initialized and connected to the database. You can use it to check if the dataset is currently running.
| Code Block | ||||
|---|---|---|---|---|
| ||||
bool isStarted = @Dataset.DB.YourDatabaseName.IsStarted; |
2. Query Execution Time: You can measure the execution time of a query by checking the time before and after executing the query.
| Code Block | ||||
|---|---|---|---|---|
| ||||
DateTime startTime = DateTime.Now;
@Dataset.Query.YourQueryName.SelectCommand();
DateTime endTime = DateTime.Now;
TimeSpan executionTime = endTime - startTime; |
3. ConnectionString: You can check the connection string used for the database to ensure it is configured correctly.
| Code Block | ||||
|---|---|---|---|---|
| ||||
string connectionString = @Dataset.DB.YourDatabaseName.ConnectionString; |
YourDatabaseName and YourQueryNamewith the actual names of the database and query you are working with in the platform.In this section...| Page Tree | ||||
|---|---|---|---|---|
|