Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Allocate memory to SELECT statement in sql server 2005 Expand / Collapse
Author
Message
Posted Thursday, January 13, 2011 3:24 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:57 AM
Points: 1,194, Visits: 2,234
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
Post #1047618
Posted Thursday, January 13, 2011 3:38 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:11 AM
Points: 6,846, Visits: 13,383
Just as a side note:
Resource Governor is available only on the Enterprise, Developer, and Evaluation editions of SQL Server (2008 and up).




Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #1047628
Posted Friday, January 14, 2011 6:40 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:09 AM
Points: 314, Visits: 2,530
Just remember that Resource Governor is new to SQL Server 2008 and this is a 2005 question.


Yeah.That's true. How did I miss that ?
Post #1047861
Posted Friday, January 14, 2011 12:05 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 13, 2014 3:03 PM
Points: 594, Visits: 655
sqlbuddy123 (1/13/2011)
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


Agreed! In SQL Server 2005, it cannot be done. Hence the recommendation to upgrade (and no longer need this forum) :)

Salutations!
Peter


Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Post #1048115
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse