Apologies for so much background, I’m trying to provide as much info as possible.
We have df installed on a Windows server 2012 R2, installed using bitmani (with apache):
- Admin Application Version: 2.1.3
- DreamFactory Version: 2.1.0
We have configured df to use MS SQL server as the db, the database itself is an azure SQL Server database.
We have a custom server side script to peform deep fetches and a stored procedures to perform deep writes (based on an object graph).
When an initial connection is made to the application, everything works really well. After a short period of usage, calls are “stalling” in the browser as no response is being returned by the server.
We have an incoming message sniffer on the server and once the server “locks up” no additional api based called are appearing in the sniffer.
If apache is restarted, connections can be made for a short period before everything “locks up” again.
Once the server has “locked up”, requests to the df admin console are successful, although this does appear sluggish at times. These df admin console requests are appearing in the sniffer.
We understand that SQL Server isn’t really supported. We’re working on a large project for a customer and we’re really concerned that this issue will prevent us using dream factory for this and future projects.
Any help or pointers would be massively appreciated. I’m new to apache having mainly developed with the MS stack for the last 10 years.