Number of records fetched by SQL (Select)
Hi,
Can we get the number of records fetched in a SQL query from dynaTrace?
Hi.I just double checked with engineering and it seems I was wrong. Row Count in the Moment is ONLY available for MongoDB databases. Other databases accessed through JDBC or ADO.NET do not provide that data with our current implementation. There is however an RFE for this that you can up-vote: RFE - Can we get the row count from oracle
sorry for the incorrect statement i made in the beginning.
Could you specify what are the JDBC Drivers that we can get the row count data?
Hi Erik
Unfortunately we dont get row counts for all SQL Statements. We only get them for certain JDBC Drivers and it then also depends on how the data is retrieved. AFAIK - if you use cursors to iterate through the resultset we dont get the row count as it is not provided by the JDBC Driver when you execute the query.
Andi
Andi, is there a sensor I should add to get numbers in the Row count column?
I'm getting dashes instead of numbers.
--Erik
There is a "Row Count" measure we capture when a SQL Statement is executed. However - this number might not be 100% accurate as we do not always get the full row count when the SQL Statement is executed.
