That's stretching the inquiries appropriate for a free support forum there Jimmy! 🙂
I am traveling today and will be pretty busy tomorrow with family stuff. But I will definitely try to get you a full reply within a few days.
Some quickies for now:
A) Can you put more than 1TB in the server?
B) Why capping max at 840GB? Seems a bit steep for a set-aside to me at first blush. Got some other big-memory consumers running on the box I presume?
C) IIRC there is a TF that can stop the NUMA memory localization. That could have a side effect (uncertain - never tested it and don't have source code access) that would result stopping the divide-by-four issue that is limiting your workspace memory.
D) Might I suggest looking at bringing in a high-level sniper to give the system and code a performance review?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service