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