This blog is intended for the FMS service operator to gain understanding of the relationship between the FMS service and the SQL Server FMS database.
When working with the FMS service and the SQL Server database connection it is important to note that each task will run in an executable thread within the executing multi-threaded FMS Service. When data is required from the database, each thread will initiate a unique session with the database to read/write the specific data. It is possible, for some long running task with minimal to no activity, for the database to close the session as part of the database service manager optimization processing. The FMS service will detect this state and cause the session to re-open when the FMS Service requires database access.