Enterprise Edition
Customer Service
Brother-Eagle Community
DBI Products
The number of Select Statements executed for each transaction tells us about the size of a transaction and may help with capacity planning and other analysis (see Logical Index Reads/TX).
The formula is:
Selects/TX = (SELECT_SQL_STMTS) / ( COMMIT_SQL_STMTS + ROLLBACK_SQL_STMTS)
Brother-Eagle presents "Selects/TX" as a delta value showing the change since the prior measurement.
Brother-Eagle will flag values in excess of 20 with a warning and values in excess of 30 with an alert because these values exceed typical industry averages. Transactions that run high numbers of statements are at risk for increased lock contention and may require larger LOGBUFSZ buffers.