How can I from SQL Queries when using Aggregate functions like count, min, max etc?
The query should be in a single line and maximum of 2000 characters. Please note that the number of queries is limited to five queries in one monitor. Also, note that the delimiter for query is new line. Total number of rows shown in the output is limited to 50 rows.
If there are more than one columns in the results, we recommend to have set a column which has string values as primary key in the monitor.
For queries involving counts we recommend to have a dummy column and use that as primary key.
Lets take for example some pending tasks for your application is stored in app_pending_tasks table and you want to monitor the number of pending tasks for the application.
Typically we will form the query as given below.
select count(*) from app_pending_tasks
The problem with the above query is it doesn't have an identifier. Instead you can form the query as given below.
For MySql, Oracle, Sybase:
---------------------------------
select 'Number of Pending Tasks', count(*) as totalcount from app_pending_tasks
Make the 'Number of Pending Tasks' the primary column.
For MsSql, Postgres, Db2:
---------------------------------
select 'Number of Pending Tasks' as NumberOfPendingTasks, count(*) as totalcount from app_pending_tasks
Make the 'Number of Pending Tasks' the primary column.
Now you can generate alarms by assigning thresholds and generate reports for 'totalcount'.
New to ADSelfService Plus?
Related Articles
APM Insight provides information on the parameters it sends to the SQL queries
The parameters in slow SQL queries can be tracked and displayed under the traces tab. We have the option to obfuscate the values of SQL query parameters using a configuration "Obfuscate SQL Parameters". It will be enabled by default. The screenshot ...Azure SQL Database - FAQ
1. Why have we removed the Diagnostic Settings dependency in Azure SQL Database monitor? Till APM v15240: Azure SQL Database was using Diagnostic Settings to perform data collection. Prerequisites had to be fulfilled to turn on Diagnostic Settings ...Queries to collect data before Id migration/Migrating from Professional to Enterprise Edition
Collect query output from Managed server / Professional Edition: To check Id range : Select min(resourceid),max(resourceid) as AM_ManagedObject from AM_ManagedObject where resourceid > 10000000; Select count(*) as AM_ManagedObject_Count from ...How is Backup Age calculated for MS SQL DB monitor?
Backup Age displays the number of hours passed since the backup operation was completed. In simple terms, it is the difference between the current time and the time at which backup was performed. Backup Age (hours) = Current Time - Backup Time By ...What are the prerequisites required to monitor 'Top 10 Queries By CPU' in KingbaseDB monitor?
1. Include the below lines in kingbase.conf file located in <Data DIRECTORY>: shared_preload_libraries = 'sys_stat_statements' sys_stat_statements.track = all 2. Execute the below commands in psql shell if the extension sys_stat_statements is not ...