Limiting no. of simultaneous queries per user | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Limiting no. of simultaneous queries per user

Is there a way to limit the number of queries an individual user can run simultaneously. Is it possible to ensure that additional queries are granted lower priorities etc.
Thanks in anticipation, Herby
No without writing you own script.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
]]>