# Database connection drops

**URL:** <https://forum.inductiveautomation.com/t/database-connection-drops/54264>\
**Category:** Ignition\
**Created:** [December 17, 2021, 9:29pm UTC](https://forum.inductiveautomation.com/t/database-connection-drops/54264 "2021-12-17T21:29:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [December 17, 2021, 9:29pm UTC](https://forum.inductiveautomation.com/t/database-connection-drops/54264/1 "2021-12-17T21:29:00Z")

</div>

Hello all,  
Ignition 8.1.11 with a redundant gateway connected to MS Sql Server.

I have a weird issue here. The connection to a database become FAULTED (shown in the database status page of the gateway). But, when that happen, the backup gateway is still connected to the database.

Both gateways are connecting to the database with the same user.

What can cause a DB connection to drop?

---

<div class="post-metadata">

**Author:** ![drojas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drojas/32/3403_2.png) [@drojas](https://forum.inductiveautomation.com/u/drojas)\
**Post date:** [December 18, 2021, 6:39pm UTC](https://forum.inductiveautomation.com/t/database-connection-drops/54264/2 "2021-12-18T18:39:56Z")

</div>

You haven’t given any context on how the Ignition gateway is connected to the database (on same server, separate servers, physical or virtual…etc.) so it is hard to give a correct answer. What kind of load is being placed on the SQL Server, did you write any queries that take a long time time to respond? Are you exceeding the maximum active connections in the connection pool? Pay attention to the database stats to see if that is showing any issues. If you are using the tag historian, sometimes the sqlth\_sce table gets too large and slows down queries in which case you need to truncate the table.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/0/3007f2d79c1e50335e8ed8b418c6d4264e8b509e.png)

---

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [December 20, 2021, 2:25pm UTC](https://forum.inductiveautomation.com/t/database-connection-drops/54264/3 "2021-12-20T14:25:23Z")

</div>

Sorry,

I’m using Ignition 8.1.11 on a VM. The MS-SQL server (Enterprise edition) is on another VM.

Thank you for the comment. I’ll keep an eye on the database stats.

For the moment, I feel like my issue may not be caused by Ignition. But it is still weird to see the main gateway disconnected and the redundant gateway (warm status) still connected.