Is there a way to monitor/trace when RO/DA begins and commits transactions?
We are witnessing a very large amount of transaction MSSQL commands from our application in the MSSQL profiler and I am curious what triggers them
Background:
We are having some weird issues with MSSQL.
At some point on some systems the application is really slow.
It is related to mssql queries (SELECT)
A series of tasks that typically take 0.2 sec now takes 10 seconds
Some selects themselves are slow in the profiler but apart from that many transactions can be seen.
These surprise me.
Note: The problem is probably not RO/DA related at all.
When I restart MSSQL without restarting RO/DA server or client everything works normal again.
I even don’t see the very large amount of transactions anymore.
So no need to spend a lot of time on it but maybe it rings a bell.
FYI: We witnessed the issue on 2 setups.
FYI2: There is one exception during/after the MSSQL service restart