Home Forums SQL Server 2005 Administering Allocate memory to SELECT statement in sql server 2005 RE: Allocate memory to SELECT statement in sql server 2005

  • January 13, 2011 at 3:24 pm

    #1273322

    Peter Trast (1/13/2011)[hr

    Just remember that Resource Governor is new to SQL Server 2008 and this is a 2005 question.

    Maybe it is time to upgrade? 🙂

    And this is exactly the kind of thing it was made for

    http://technet.microsoft.com/en-us/library/bb895232.aspx

    And only CPU and memory can be governed, by a percentage of the total, with a minimum and maximum for each workload definition. This is definitely a feature worth upgrading to 2008 for.

    And hence the Answer. I was referring to SQL 2005 as this is SQL 2005 forum

    Thank You,

    Best Regards,

    SQLbuddy