tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard
verified publisher icon microsoft

Max server memory computation

Open aguzev opened this issue 5 years ago • 0 comments

https://github.com/microsoft/tigertoolbox/blob/5c432392f7cab091121a8879ea886b39c54f519b/BPCheck/Check_BP_Servers.sql#L1968

While @numa and @numa_nodes_afinned both are positive, this comparison

(@maxservermem/@numa) * @numa_nodes_afinned > (@systemmem/@numa) * @numa_nodes_afinned

looks equivalent to

@maxservermem > @systemmem

Was this intentional?

aguzev avatar Dec 14 '20 16:12 aguzev