Showing results for 
Show  only  | Search instead for 
Did you mean: 
AppDynamics Team

How does a user determine the number of business transaction (BT) events that are published to the Analytics or Events Service Server by each application?


Some users may see the following events limit message in the Analytic Agent logs and need to determine the total number of events being published.

For action [EVENT_UPSERT], you have reached the events limit of [22500000]  for account [XYZXYZXYZXYZXYZ] and event type group [biz_txn_v.*|custom_.*]



One business transaction can traverse many tiers. In each tier, one business transaction can traverse one node. One node produces one event for each BT when the transaction is synchronous. For async transactions, multiple events may be generated by a node for a single request.


To calculate how many events a BT generates, use the following formula to estimate the number of tiers/nodes that are sending data to the Analytics Agent.


number of events for one business transaction = calls per minute multiplied by number of tiers



Use the following ADQL query for each application, and add the results to find the total number of BT events published across the applications to the Events Service or Analytics Server.


SELECT transactionName, distinctcount(segments.tier) AS 'Tiers', count(*) as 'Transactions', distinctcount(segments.tier) * count(*) AS 'Events' FROM transactions WHERE application = "ECommerce" LIMIT 100





Note: On the above query, there is a limit of 100 results as its an aggregate function. Users with many BTs may hit the limit. 


As an alternative, use the following query for the BT Transaction Analytics License consumption:


SELECT count(segments.node) FROM transactions
SELECT count(*) FROM transactions



Screen Shot 2017-07-19 at 8.59.52 PM.png




 Related Links:



@Mohammed.Rayan is it possible get the count for HR's which were violated?

Version history
Last update:
‎03-19-2020 02:07 PM
Updated by:
On-Demand Webinar
Discover new Splunk integrations and AI innovations for Cisco AppDynamics.

Register Now!

Observe and Explore
Dive into our Community Blog for the Latest Insights and Updates!

Read the blog here