i have a Datasource that connects to an MS SQL instance. i’m noticing a lot of unexpected locking and even deadlocks when creating a new Suite using a simple custom SQL query for the data. Is there a way to prevent this from happening, maybe changing the isolation level associated with the connection?
I’m using SQLAlchemy, PYODBC and Microsoft ODBC Driver 17 for SQL Server (x64) for the connection.
Any direction is greatly appreciated.
- Sean Fitz