topic Slow response and excessive SQL chatter in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/slow-response-and-excessive-sql-chatter/m-p/257168#M210298 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>We're using Alfresco 3.2 with a SQL Server 2008 database. We've noticed that the Alfresco server is very slow to return page requests, taking 15 seconds to return a view with 10 spaces. It takes longer with more spaces. </SPAN><BR /><BR /><SPAN>Now, I wiresharked the connection between Alfresco and SQL server to monitor the traffic between the two, and noticed thousands of duplicated SQL commands during the page query. The following command sequence is sent thousands of times:</SPAN><BR /><BR /><SPAN>.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……&lt;…………………..@….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……&lt;…………..D….I.F. .@.@.T.R.A.N.C.O.U.N.T. .&gt;. .0. .C.O.M.M.I.T. .T.R.A.N……&lt;…………..H….I.F. .@.@.T.R.A.N.C.O.U.N.T. .&gt;. .0. .R.O.L.L.B.A.C.K. .T.R.A.N……&lt;……………….I.F. .@.@.T.R.A.N.C.O.U.N.T. .&gt;. .0. .C.O.M.M.I.T. .T.R.A.N.</SPAN><BR /><BR /><SPAN>Before the page is returned. Any idea what would cause this?</SPAN><BR /><BR /><SPAN>Here's the database section from the global properties file:</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># SQLServer connection (note you must enable TCP protocol on fixed port 1433)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>db.driver=net.sourceforge.jtds.jdbc.Driver</SPAN><BR /><SPAN>db.url=jdbc:jtds:sqlserver://${db.host}:${db.port}/${db.name}</SPAN><BR /><SPAN>db.txn.isolation=4096</SPAN><BR /><BR /><SPAN>Any tips?</SPAN></BODY></HTML> Mon, 25 Apr 2011 10:06:36 GMT stewilko 2011-04-25T10:06:36Z Slow response and excessive SQL chatter https://connect.hyland.com/t5/alfresco-archive/slow-response-and-excessive-sql-chatter/m-p/257168#M210298 Hello,We're using Alfresco 3.2 with a SQL Server 2008 database. We've noticed that the Alfresco server is very slow to return page requests, taking 15 seconds to return a view with 10 spaces. It takes longer with more spaces. Now, I wiresharked the connection between Alfresco and SQL server to monit Mon, 25 Apr 2011 10:06:36 GMT https://connect.hyland.com/t5/alfresco-archive/slow-response-and-excessive-sql-chatter/m-p/257168#M210298 stewilko 2011-04-25T10:06:36Z Re: Slow response and excessive SQL chatter https://connect.hyland.com/t5/alfresco-archive/slow-response-and-excessive-sql-chatter/m-p/257169#M210299 <HTML><HEAD></HEAD><BODY><SPAN>Tips, yes upgrade to a version which is de-hibernated.</SPAN></BODY></HTML> Mon, 25 Apr 2011 21:24:22 GMT https://connect.hyland.com/t5/alfresco-archive/slow-response-and-excessive-sql-chatter/m-p/257169#M210299 mrogers 2011-04-25T21:24:22Z