# Transaction Group Max limit **URL:** \ **Category:** Ignition\ **Created:** [March 18, 2018, 6:53pm UTC](https://forum.inductiveautomation.com/t/transaction-group-max-limit/17406 "2018-03-18T18:53:37Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![roshanbhosale](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/roshanbhosale/32/4899_2.png) [@roshanbhosale](https://forum.inductiveautomation.com/u/roshanbhosale)\ **Post date:** [March 18, 2018, 6:53pm UTC](https://forum.inductiveautomation.com/t/transaction-group-max-limit/17406/1 "2018-03-18T18:53:37Z")
HI, I would like to know the max.limit of transaction groups that can be defined in ignition 7.8.4 version, having the license of SQL-Bridge module. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 18, 2018, 11:58pm UTC](https://forum.inductiveautomation.com/t/transaction-group-max-limit/17406/2 "2018-03-18T23:58:52Z")
I wasn’t aware that there is a limit. Just how much processing power you need in your gateway. ---
**Author:** ![roshanbhosale](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/roshanbhosale/32/4899_2.png) [@roshanbhosale](https://forum.inductiveautomation.com/u/roshanbhosale)\ **Post date:** [March 19, 2018, 3:19am UTC](https://forum.inductiveautomation.com/t/transaction-group-max-limit/17406/3 "2018-03-19T03:19:51Z")
Currently, installed system has more than 400 transaction groups and total around 80 thousand transaction tags defined, where 300 transactions /second executes.which are divided into 1 second, 5 seconds and 30 seconds execution timers. I want to know for sure, whether the ignition can accommodate more transaction groups without degrading the performance. Currently, the Ignition server is installed in VM environment with 8 GB of RAM and Windows server. Sometimes the transactions group fails to execute with an error saying “Transaction Process was deadlocked on lock resources with another process and has been chosen as deadlock victim” The RAM consumption of VM environment is around 7.72GB/8GB, I think the reason behind deadlocks might be the RAM resource starving. But is there any other reasons behind the deadlock situations? I forgot to mention that some groups are having output target as input paraments of database procedures and some are historian groups logging data to the database per second. ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [March 19, 2018, 11:45am UTC](https://forum.inductiveautomation.com/t/transaction-group-max-limit/17406/4 "2018-03-19T11:45:14Z")
You have two or more transaction sessions trying to hit up the same resources at the same time. One session can wait for the other, and vice versa. Someone has to lose, and SQL Server chooses the loser. > > [@roshanbhosale](#): > > I forgot to mention that some groups are having output target as input paraments of database procedures Well, there you go. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 19, 2018, 12:56pm UTC](https://forum.inductiveautomation.com/t/transaction-group-max-limit/17406/5 "2018-03-19T12:56:48Z")
I would also suggest that you definitely don’t have enough RAM set up for Ignition. When you chart the ram usage in Ignition, it should be a sawtooth that peaks below 90% of the amount allowed for Ignition and the bottom should dip below 50% of allowed. If you aren’t configured to use G1GC, do so immediately. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [March 19, 2018, 6:07pm UTC](https://forum.inductiveautomation.com/t/transaction-group-max-limit/17406/6 "2018-03-19T18:07:57Z")
There is no limit to the number of groups you can have, but there _is_ a limit to the thread pool used; extremely high concurrency environments _may_ benefit from increasing this limit - talk to support.