I have noticed similar issues when using 4D fn calls from single user to 4D. when testing with light load not problem and it appears it is not a synchronous call but under any regular to heavy load, it appears synchronous. Indeed at 2 or 3 summits again Neil Dennis and I had this discussion. He wrote code and was convinced it was now an asynchronous call but Sergei from 4D said it was synchronous so perhaps a similar thing is happening
Regards Chuck On Thu, Aug 24, 2017 at 11:11 AM, Stephen J. Orth via 4D_Tech < [email protected]> wrote: > Jeff, > > We have experienced a similar type of situation when using 4D SQL (to > extract data from a MS SQL server). As best we can tell, the SQL call is > blocking, locking out all other processing. > > Were you running this from the Server, or a Client? > > > Steve > > ********************************************* > Stephen J. Orth > The Aquila Group, Inc. Office: (608) 834-9213 > P.O. Box 690 Mobile: (608) 347-6447 > Sun Prairie, WI 53590 > > E-Mail: [email protected] > ********************************************* > -----Original Message----- > From: 4D_Tech [mailto:[email protected]] On Behalf Of Jeffrey > Kain via 4D_Tech > Sent: Thursday, August 24, 2017 10:06 AM > To: [email protected] > Cc: Jeffrey Kain <[email protected]> > Subject: 4D server "pausing" every 15 minutes > > I just made a very interesting discovery and thought I'd share it with the > group -- it's timely given the recent blog post by 4D about dashboards. > > We're huge fans of dashboards here at Sweetwater, and our dashboard tool > of choice is Prometheus. We use this on all our major servers -- Exchange, > Postgres, MySQL, and others. We decided to add our 4D Server to the mix. > This server is a 24-core Dell server running Windows Server 2012 > Datacenter, and it hosts, at peak, around 540 simultaneous 4D users and > around 3000-3500 4D processes. It runs great and it is extremely stable. > > For the 4D Server dashboard, we feed certain statistics directly from 4D > via a SQL function call (poor-man's web service), and we recently installed > the Prometheus wmi_exporter tool which exports operating system-related > data from the Windows Management Instrumentation Service (WmiPrvSE.exe) > into Prometheus format. The wmi_exporter tool is very fast and you have to > look fast to see it consume any resources at all, but when it is running, > the Microsoft WmiPrvSe.exe process periodically wakes up and consumes 4% of > our 24-core server for 10-12 seconds. This happens about once every 15 > minutes. > > When this is happening, 4D Server slows to a crawl. Clients start to > beach-ball, pause, or have their network connections broken and throw > runtime errors. Some astute users actually noticed this 15 minute cycle, > and after I dug into it it turns out that is exactly the case and is 100% > reproducible. > > We had the dashboard turned on all day Tuesday, and we received dozens of > support tickets from users complaining about slow performance in 4D. On > Wednesday, we ran without the seemingly harmless wmi_exporter service > enabled, and we didn't receive a single support ticket. > > My guess is that wmi_exporter may be asking for a particular statistic > that takes Windows a significant amount of time to collect. We may try to > scale it back and turn our measured statistics on one by one until we can > determine the problem. But until then, we can live without the dashboard > (beautiful as it was on the 60-inch 4K display...). > > Jeff > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** -- ----------------------------------------------------------------------------------------- Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed Solutions, Inc. Brookline, MA 02446 USA Registered 4D Developer Providers of 4D, Sybase & SQL Server connectivity http://www.informed-solutions.com ----------------------------------------------------------------------------------------- This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
