Jeff, Yes, that is what I was thinking made the most sense based upon your explanation. It sure seems like the call is blocking, and stopping all other processing on the Server. At the very least, it is consuming most of the processing power. Can this be done from a Client instead?
On a side note, we have been hoping for many years 4D could figure out how to allow us to "pragmatically" run what effectively are stored procedures on the server. However, in every attempt I have made to move code over to the server, it simply fails because all the process power is sucked away from users when executing these procedures. Very frustrating... Steve -----Original Message----- From: 4D_Tech [mailto:[email protected]] On Behalf Of Jeffrey Kain via 4D_Tech Sent: Thursday, August 24, 2017 10:17 AM To: [email protected] Cc: Jeffrey Kain <[email protected]> Subject: Re: 4D server "pausing" every 15 minutes From Steve: > On Aug 24, 2017, at 11:11 AM, Stephen J. Orth <[email protected]> > wrote: > > 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? This was running on the 4D Server. When WmiPrvSE.exe wakes up every 15-20 minutes and runs for about 10-20 seconds, it would pause, disconnect, or cause the spinning beach-ball on all the connected clients. From Spencer: > could this have anything to do with new volume shadow copy feature? I don't think so, just because this service only becomes active when we're running the wmi_exporter which is an open source project designed to get this data from Windows into Prometheus format. When we disable wmi_exporter, then WmiPrvSE.exe stops waking up and causing mayhem with 4D. ********************************************************************** 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] **********************************************************************
