limit a user account or sp using too much resource | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

limit a user account or sp using too much resource

We are using SQL 2K with sp4. We have a stored procedure that is using a lot of CPU resource. This sp is run by a specific SQL user account. Is there a way I can limit the resource (CPU) being used by this sp. For example, if the system detects this SP or the user account, this sp can only use 20% of the CPU. Any help is very much appreciated. wingman
This is not currently possible, but Microsoft is considering adding a similar feature to the next version of SQL Server. For now, I would recommend seeing how you can tune the query so that it runs better. —————————–
Brad M. McGehee, SQL Server MVP
]]>