go to post Victor Tamotsu · Aug 8, 2019 Hi @Alexei Konoferchuk ,I had a similar issue in Caché 2012 on a Windows enviroment. I my case I got a different error code, but the same error description:System.Data.Odbc.OdbcException (0x80131937): ERROR [08S01] [Cache ODBC][State : 08S01][Native Code 461] [F:\Matrix\MatrixDiagnosis\MatrixServico.exe] Falhou a conexão via cconnect: TCP connect() failed - exception satisfied select(). Reason: (10061, 0x274d) No connection could be made because the target machine actively refused it. Note that the Native Code 461 is a returned exception from the Intersytems ODBC driver, but the error message is thrown by Windows TCP. That means that we have to understand why this code is different for your scenario, but this Windows message has some known reasons:If Windows is up, but Caché service isn't;You reached one of Windows TCP limit (check this link for more discussion about);The CPU workload is too heavy and can't process the new TCP connection, resulting in a full TCP backlog (check this link for more);There are network issues, like a misconfigured virtual IP or a duplicate IP address that could make the ODBC request reach a wrong server and reach the case number one.So you will have to understand if you a reaching one of those scenarios. If you have a high CPU usage, maybe you are possibily entering in the case number 3. I would check the CPU queue length (using Perfmon) to confirm. If you there are just workload peaks, then a Windows TCP tunning and a backlog extension in Caché could help you. If this is a common case, then you will have to check your CPU resources.In the fourth case, you would have others ODBC errors before get this error... Sorry about my bad english! Good luck!
go to post Victor Tamotsu · Nov 6, 2017 Hello Eduardo,Thanks for the tip! I had read some of the articles and they are all great, all very good. I'm sure I'll use the knowledge of the @murray articles to add to my support and scaling activities. There are articles that @murray explain how to compare two different server proccessors, but how to understand the server as a whole?I would like to find a method of comparing two different infrastructure environments. My clients create different workloads profiles during their production, so compare those servers is very difficult for me. I would like to have a standardized and well-accepted formula for:- understand the power of a new server before deploying my system;- understand the server / envoriment response after a change, such as a hardware upgrade or software parameterization.Possible physical and logical bottlenecks can be evidenced even before testing on my application by the client or my team. I think that even though it does not contain the details of my system usage, that kind of tool can create parameters for future analysis. My question is whether TPC-E can be used as a solution for these cases. Is there a similar tool for the Caché world?
go to post Victor Tamotsu · Nov 6, 2017 Hi John, Yeah, you're right, sorry guys! Both edited, thanks!
go to post Victor Tamotsu · Mar 6, 2017 Wow, thanks for your feedback! With your case I can study the use of load balance for ODBC hopeful.
go to post Victor Tamotsu · Mar 3, 2017 Thanks Dmitry! I'm gonna study HAproxy and test in my envoriment. Does anyone already used HAproxy for ODBC connections in Caché?
go to post Victor Tamotsu · Mar 2, 2017 Hi, thanks for the reply.I have two ECP application servers connected in a ECP data server. The ODBC clients are connected to my two ECP application servers and I want do load balance of their connections. My servers runs in Windows Server 2008 R2. I am wondering if someone has alreadey used a load balance solution, like Microsoft NLB or HAProxy, for this cenario.
go to post Victor Tamotsu · Feb 2, 2016 Hi, thanks for this post. I just introduced to this community and loved the idea of having my questions about Intersystems products shared. Are there any plans to support RSS?
