Topic: sql server 2016 enterpise. Determination of optimal number of kernels for
We have functioning corporate data store on the virtual machine with the selected 64 kernels and a copy of server MS of a SQL Server 2016 Enterprise. To productivity at present questions are not present. But there was a question on purchase of licenses "Under a kernel". To buy on all already selected on kernels allows nobody. There is a desire to understand what optimal number of kernels for support of normal productivity of ours . For these purposes we want to adjust counters and to look at them in peak loadings with various number of the kernels selected . Actually a question: whether such approach is real, what counters is better to use? Or it is possible to approach to the decision of the given task still somehow?