Post reply

Process resource priority

  • May 19, 2005 at 9:25 am

    #86547

    Hello Everyone,

    Can anyone tell me any SQL commands that will give one stored procedure or process a lower resource priority than another stored procedure or process?

    Or of some way to do this.

    Thanks,

    Kris

  • May 19, 2005 at 10:13 am

    #559904

    The only thing I know of that you can do is SET DEADLOCK_PRIORITY. This only controls which spids would get killed if a deadlock occurs (you're basically designating this SP to be killed, instead of letting SQL Server decide, and there are even a few caveats on top of that). I don't think that you can actually give a particular spid more of a resource priority like you can with Windows processes.

    Check out deadlock_priority in books online.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply