I'm dealing with some performance issues on SQL Server 2012. The client application indicates that the SQL time to load a page is over 2.5 seconds with a total loading time of more than 3 seconds. For this page it executes more than a few 1000 queries. In the trace I can see that it does the following a lot.
IF @@TRANCOUNT > 0 COMMIT TRAN (see screenshot of default tace).
What is the impact of this constant trancount check on the database? Can this be the cause of the issue? The queries itself take a very short time (microseconds) and other indicators show that the SQL server is healthy so I'm looking at overhead caused by these type of things. I've eliminated the network too.