I’m not the strongest DB guy, especially in SQL, but figured I might be able to get some help here.
I’ve got an SQL Express instance running side by side with Ignition on a development computer. Once we have a few transactions executing around the same time, the database ends up having processes get suspended in waiting for another task. These tasks seem to range from stored procs, to named queries, all of which are fairly simple.
Any ideas of where I should start to look to resolve this issue?