Generally - Rule of thumb is to configure physical processors-1 CPUVPS on a decicated database
server - in your case 23. I guess this setting should be ok for most circumstances.
But -if you determine that a) your physical CPUs are still mostly idle and b) your database performance is CPU bound (lots of threads in ready queue , spending lot of time in ready wait) - you might further increase CPUVPs .
For more details
Animated Business Whiteboard
Wieloczynnościówki, czyli kilka w jednym
Posty: 1 • Strona 1 z 1