Versions Compared

Old Version 4

changes.mady.by.user user-05e19

Saved on

compared with

New Version 5

changes.mady.by.user Support

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

Monitoring

database connections is crucial for system reliability. Ensure correct data access with these methods:
  1. IsStarted Property: Check if the dataset is active.
  2. Query Execution Time: Measure query execution duration.
  3. ConnectionString: Verify database configuration.
Use these tools

Database Connections is essential to maintaining a reliable and efficient system. By keeping track of Database Connections, you can ensure your data is accessed and updated correctly. This page will present the tools used to maintain an efficient platform

. Replace placeholders with actual database and query names

.

On this page:

Table of Contents
maxLevel3

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:

There are 3 used methods to ensure correct data access.

  • Is Started

  • Query Execution Time

  • Connection String

See each one of them in more detail in the sections below.

Is Started

This property indicates if the

dataset is started, meaning it has been

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. 

Code Block
languagec#
titleExample
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. See the example code below.

 

Code Block
languagec#
titleExample
DateTime startTime = DateTime.Now;
 @Dataset.Query.YourQueryName.SelectCommand();
 DateTime endTime = DateTime.Now;
 TimeSpan executionTime = endTime - startTime;
3. ConnectionString:
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
languagec#
titleExample
string connectionString = @Dataset.DB.YourDatabaseName.ConnectionString;

 Note
Please note that these are just examples, and you will need to replace YourDatabaseName and YourQueryNamewith the actual names of the database and query you are working with in on within the platform.

 
In this section...
 Page Tree
root@parent
spacesV10