I was specifically interested in using Resource governor and its functionality , when i look at it it sounds like as simple as i think, Like create user resource pool , workgroups and Classifier UDF. But i am looking deeply in to this functionality
do any one recommend Books or online blogs or some kind of scripts or stored procedures to figure out current load and usage particularly how to figure out below things
What is the CPU requirement?
Determine a CPU bandwidth estimate by multiplying the average total CPU usage per request by the average number of requests per second.
The maximum, average, and standard deviation of CPU usage can be used to determine whether a maximum CPU limit is necessary.
What is the number of concurrent requests?
Use the maximum and average number of concurrent requests statistics to determine the minimum concurrency factor.
What is the total memory that is needed?
Use the maximum and average total memory used to determine the memory requirement.
How much memory is needed for a single query?
Use the maximum and average memory per query statistic to determine how much memory is needed.
Is any query not running due to lack of memory?
Use the average time waiting on memory queue statistic to determine whether any queries are blocked because of memory availability.