Is that possible that for one single user, I will limit somehow procesor resources that can be utilized? For a single query, I can use something like:
Option (MAXDOP 4)
Is that possible to limit similar way all queries that were executed by a specific user? Of course, if the user will run 10 separate queries I would like not only they will be limited but a limit will be set for cumulative overload.
>Solution :
See if SQL Server Resource Governor is what you need.
SQL Server Resource Governor is a feature that you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the amount of CPU, physical I/O, and memory that incoming application requests can use.
I don’t know if you can limit per-user, but you can set workload groups and assign users to one.