1 Dec
2017
1 Dec
'17
4:24 p.m.
There's definitely no reason to be running TWO realtime AV on *any* machine.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
On Fri, 1 Dec 2017, at 02:29 PM, Eric Selje wrote:
> The slowness is almost certainly caused by running Symantec and Windows
> Defender on the server. There's almost no reason to run realtime A/V on a
> server, IMO. All files must go through a workstation, so that's the first
> line of defense.
>
> Eric
>
> On Fri, Dec 1, 2017 at 7:15 AM, Jürgen Wondzinski juergen@wondzinski.de
> wrote:
>
> > Hi Mike,
> >
> > Just to be clear: If you didn't adhere to the Rushmore-optimization topics
> > then they are correct, as this will definitely bring down the whole table
> > to
> > the client, if VFP has to do a full-table-scan to find a record. Also any
> > "REPLACE ALL ..." will do the same, since data-processing is always at
> > client-side. Thus you'd better check your coding twice :)
> >
> > Then for optimization, there are two things to check: a) Network-speed, b)
> > Server-Speed
> >
> > a) Network-Speed in our case is depending on the use of SMB1 or SMB2/SMB3.
> > SMB1 is used in WinXP/Server2003, SMB2 is Vista and S2008, SMB2.1 is Win7
> > and S2008/R2, SMB3 is Win8 and S2012, SMB3.1 is Win10 and S2016. SMB1 was
> > a
> > block-based transfer, whereas starting with SMB2 it got a stream-based
> > transport. Even if you could take the easy way out and disable SMB2/3
> > either
> > on server or client side, it's not a valuable recommendation, since modern
> > Windows technologies are depending on those additional features of the
> > newer
> > standard. You better live with those.
> > http://support.microsoft.com/kb/2696547
> >
> >
> > The effect which Tracy mentioned (single network user is faster than
> > multiple users), is only partly related to that topic, but mostly with the
> > dreaded Opportunistic Locking (or short "OpLock", which corrupts our CDX
> > and
> > data). SMB2/3 (as a streaming protocol) holds a local buffer to accomodate
> > datastreams as well as OppLocks. The common solution is to disable that
> > caching, which effectively kills the OpLocks problem. For that you have to
> > set three Registry Keys at the CLIENT, nothing to do at server side. You
> > can/should check for correct settings in your app at startup, but you
> > (normally) can't change those settings on the fly, since you need Admin
> > Rights for that. (Thus you'd better package those into your installer)
> > https://technet.microsoft.com/en-us/library/ff686200%28WS.10%29.aspx
> >
> > --------------------------------------
> > b) Then there are several tweaks at the server level. Unfortunately there
> > are a lot of Hotfixes for Server 2008, 2008/R2, 2012 and 2012/R2, which are
> > all related to those SMB and network problems. Thus you need those Admins
> > to
> > cooperate, if they want to make their users happy, as they need to get
> > their
> > server patched.
> >
> > See here for Server 2008:
> > https://support.microsoft.com/en-us/help/2473205/list-of-
> > currently-available
> > -hotfixes-for-the-file-services-technologie
> > See here for Server 2012:
> > https://support.microsoft.com/en-us/help/2899011/list-of-
> > currently-available
> > -hotfixes-for-the-file-services-technologie
> >
> >
> > --------------------------------------
> > Besides of those Hotfixes there are three more settings: FairShare, SMB
> > Signing and SMB Secure Negotiaton (if data resides on a NAS).
> > Here are some links for How-To:
> > http://www.ryslander.com/disable-fair-sharing-in-windows-server/
> > http://mctexpert.blogspot.de/2011/02/disable-smb-signing.html
> > https://support.microsoft.com/en-us/help/2686098/-system-
> > error-2148073478--e
> > xtended-error--or-invalid-signature-error-m
> >
> > Also, if that dataserver is actually a HyperV hosted maschine, it should be
> > a Gen1 Machine, not a Gen2 (the file-extension should be *.VHD, not
> > *.VHDX).
> > http://itgroove.net/thebeagle/2014/07/30/hyper-v-hellsort-of/
> >
> > P.S.
> > If you wonder why I have all those infos available, I just had a session
> > about that stuff at the german DevCon. See, you should have gone there! <g>
> >
> > wOOdy
> >
> > "*´¨)
> > ¸.·´¸.·*´¨) ¸.·*¨)
> > (¸.·´. (¸.·` *
> > .·`.Visual FoxPro: It's magic !
> > (¸.·``··*
> >
> >
> >
> >
[excessive quoting removed by server]