Number of records fetched by SQL (Select)
Hi,
Can we get the number of records fetched in a SQL query from dynaTrace?
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.
Andi, is there a sensor I should add to get numbers in the Row count column?
I'm getting dashes instead of numbers.
--Erik
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
Could you specify what are the JDBC Drivers that we can get the row count data?
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.
