SQL Server 2005 user prioritization

I currently have a SQL Server 2005 database that is accessed by multiple users. Is it possible to have SQL开发者_Python百科 give processing priority to specific users based on their login names? ie, if Alice and Bob are both running queries simultaneously, I want to ensure that Bob is given priority over Alice.

---

SQL Server 2008 has a new feature called Resource Governor that will do what you are asking for.

http://msdn.microsoft.com/en-us/library/bb933866.aspx

You are using SQL 2005 which does not have this ability.