Home Forums SQL Server 2012 SQL 2012 - General Is it possible to limit Maximum Workspace Memory or the portion of it allocated to a single query? RE: Is it possible to limit Maximum Workspace Memory or the portion of it allocated to a single query?

  • 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