Jony, October 13, 2016 - 11:30 am UTC
Suppose we create a procedure take a 2 minute to run and get 10,000 rows from multiple tables and applying a aggregate functions and lots of group by clause.
Now my question is when this query runs our OS CPU time is goes to 100 percentage but i want to assign some resources to the procedure which never goes to 20% of cpu
how to possible to assign cpu and other resource to particular procedure?