cancel
Showing results for 
Search instead for 
Did you mean: 

Excessive SQL chatter (revisited)

lwilkinson
Champ in-the-making
Champ in-the-making

This was previously asked in Slow response and excessive SQL chatter Alfresco 3.4 + SQL Server 2008. We're running Alfresco 5.1.1 with SQL Server 2012, and I find wireshark trace still shows this chattiness.

.S.E.T. .I.M.P.L.I.C.I.T._.T.R.A.N.S.A.C.T.I.O.N.S. .O.F.F……<…………………..@….S.E.T. .I.M.P.L.I.C.I.T._.T.R.A.N.S.A.C.T.I.O.N.S. .O.N……<…………..D….I.F. .@.@.T.R.A.N.C.O.U.N.T. .>. .0. .C.O.M.M.I.T. .T.R.A.N……<…………..H….I.F. .@.@.T.R.A.N.C.O.U.N.T. .>. .0. .R.O.L.L.B.A.C.K. .T.R.A.N……<……………….I.F. .@.@.T.R.A.N.C.O.U.N.T. .>. .0. .C.O.M.M.I.T. .T.R.A.N.

Thoughts as to what this is and is it necessary? I'm seeing many of these every second in the trace.

Thanks in advance.

1 ACCEPTED ANSWER

afaust
Legendary Innovator
Legendary Innovator

What did Alfresco Support say? Since this is an Enterprise-only supported database and an Enterprise Edition release, they should be the first to contact.

Having said that, any request / background processing job will trigger the initialisation of a DB transaction for the sake of isolation from other concurrent operations. Now unfortunately the initialisation of the transaction is automatic and unaware of what a specific piece of code may choose to do. There are cases / operations that determine they don't need to do anything after having caused the transaction to be initialised, which ends up looking like superflous chatter. In some cases the code checking if something needs to be done actually intends for a database interaction to occur, but because Alfresco may cache data in second level caches won't actually end up calling the database.

There are a number of known reasons / patterns that can cause this chattiness. It would need correlation with operations running in your system and the configuration of the system to pinpoint individual code lines that could be optimised to reduce chatter. But we will likely never eliminate it alltogether.

View answer in original post

2 REPLIES 2

afaust
Legendary Innovator
Legendary Innovator

What did Alfresco Support say? Since this is an Enterprise-only supported database and an Enterprise Edition release, they should be the first to contact.

Having said that, any request / background processing job will trigger the initialisation of a DB transaction for the sake of isolation from other concurrent operations. Now unfortunately the initialisation of the transaction is automatic and unaware of what a specific piece of code may choose to do. There are cases / operations that determine they don't need to do anything after having caused the transaction to be initialised, which ends up looking like superflous chatter. In some cases the code checking if something needs to be done actually intends for a database interaction to occur, but because Alfresco may cache data in second level caches won't actually end up calling the database.

There are a number of known reasons / patterns that can cause this chattiness. It would need correlation with operations running in your system and the configuration of the system to pinpoint individual code lines that could be optimised to reduce chatter. But we will likely never eliminate it alltogether.

lwilkinson
Champ in-the-making
Champ in-the-making

Axel, thanks. I'll start with support, as you suggest.

Getting started

Tags


Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.