Is there a real world benefit (or penalty) from running dedicated SQLA Windows servers with the -gb option set to high? As Breck observed here the documentation is sparse. I haven't been able to discern any particularly good (or bad) effects. We have tended to include it but probably on no more solid basis than it sounds like a good thing. However I'm also aware of the generally very sound SQLA principle of "don't mess with the default settings unless you have a good reason to".
It may be that it only comes into play when the CPUs are stressed.
As was observed in the old newsgroups, the never ending quest for the undocumented "make everything work better" switch continues :)
asked 24 Aug '16, 08:04