Sachin Nandanwar (1/12/2011)
It can be done for a particular login using resource governer but not for a query or a SP.What you do basically is create resource pool and assign that resource pool to that particular login.So any query or SP that is run with that particular login will only have memory resources defined in resource governer .
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.
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems