Resource governor configuration – Which limits (maximum or minimum) is more critical for performance?
We configure both minimum and maximum limit of CPU and Memory for each RESOURCE POOL in Resource Governor. While we should be very careful to decide on both these limits, did you ever wonder which one is most critical?
While there is no direct answer to this, as per me we should be more careful to configure the minimum limit. If we do not guarantee a proper minimum limit for the resource, there is a good chance that resource (which means the applications connecting via the specific Resource Pool) will face a serious degradation of performance.
So think very cautiously before deciding both limit for RESOURCE POOL . Especially a wrong configuration of Minimum limit can really hurt the performance of your application. However in reality you should pay equally critical attention to decide both minimum and maximum value.
Comments