I need some advise for solve next task:
I have configured and fully worked Mirroring on MS SQLServer 2014 Standard Eddition.
In last time i see what my APPS generate 100% overload Load CPU.
On Server set 2 socet on 8 Core + HyperTrading on, in summ 24 logical core, all load on 100%.
I want to solv this problrm by upgrade CPU, but how i understand 24 logical core maximum CPU on hardware server jn Standard Eddition, and i must ugrade license from Standard Eddition to Entrerprise.
Please, advise me how can i solve this issue