Datasets Monitor (Reference)
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.
provides real-time visibility into server-side database operations for Tables and Queries during runtime. The Datasets Monitor displays:
- Server operation status
- Row counts and results
- Error tracking
- Execution status
- Performance metrics
Access via Datasets → Monitor when connected to runtime.
In this page:
Table of Contents maxLevel 2 minLevel 2 indent 10px exclude Steps style none
Monitor Table Properties
| Property | Description | Runtime Access |
|---|---|---|
| Name | Table or Query identifier | @Dataset.Table.<Name> |
| SourceID | Original configuration ID | @Dataset.Table.<Name>.SourceID |
| RowCount | Total rows returned | @Dataset.Table.<Name>.RowCount |
| Disable | Object disabled state | @Dataset.Table.<Name>.Disable |
| LastStatus | Operation result (0=success) | @Dataset.Table.<Name>.LastStatus |
| LastStatusMessage | Error description | @Dataset.Table.<Name>.LastStatusMessage |
Runtime Property Access
Access monitor properties in displays or scripts:
Table Properties
csharp
// Get table status
int rows = @Dataset.Table.ProductionTable.RowCount;
int status = @Dataset.Table.ProductionTable.LastStatus;
string error = @Dataset.Table.ProductionTable.LastStatusMessage;
// Check for errors
if (@Dataset.Table.ProductionTable.LastStatus != 0)
{
// Handle error condition
LogError(@Dataset.Table.ProductionTable.LastStatusMessage);
}Query Properties
csharp
// Monitor query execution
int queryRows = @Dataset.Query.MyQuery.RowCount;
bool isDisabled = @Dataset.Query.MyQuery.Disable;
// Validate results
if (@Dataset.Query.MyQuery.LastStatus == 0 && queryRows > 0)
{
// Process successful query
}Monitoring Scope
Server Operations Only
- Displays server-side executions
- Does not show client-initiated operations
- Tracks TServer database interactions
Client-Side Monitoring
For client operations, use runtime attributes directly:
- Check status properties after execution
- Monitor from displays or client scripts
- Track individual client results
Using Monitor Data
Health Monitoring
csharp
// Check all tables health
bool allHealthy = true;
if (@Dataset.Table.Table1.LastStatus != 0 ||
@Dataset.Table.Table2.LastStatus != 0)
{
allHealthy = false;
// Alert operator
}Performance Tracking
csharp
// Monitor row counts
if (@Dataset.Table.LargeTable.RowCount > 10000)
{
// Consider pagination
}Error Logging
csharp
// Log all errors
public void LogDatasetErrors()
{
if (@Dataset.Table.MyTable.LastStatus != 0)
{
string error = string.Format(
"Table {0} Error: {1}",
"MyTable",
@Dataset.Table.MyTable.LastStatusMessage
);
WriteToLog(error);
}
}Best Practices Checklist
- Monitor regularly - Check status periodically
- Log errors - Track all error messages
- Set thresholds - Alert on row count limits
- Track performance - Monitor execution times
- Document issues - Keep error history
- Create dashboards - Display key metrics
Troubleshooting
No data in monitor:
- Verify runtime is active
- Check Designer connection
- Confirm server operations
- Review object configuration
High error counts:
- Check database connectivity
- Review SQL syntax
- Verify permissions
- Monitor database health
Performance issues:
- Check row counts
- Review query complexity
- Monitor network latency
- Optimize database indexe
In this section...
| Page Tree | ||||
|---|---|---|---|---|
|
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