![]() ![]() While changing the product key, there is no “real” edition upgrade. These are the same steps which are required to upgrade the edition of SQL Server. The steps to update the product key is very simple. Here is how the CPU utilization looks on the server. Once the product key got updated successfully, SQL Server was able to use all the core of the box. So, I updated the SQL Server Edition from “Server+CAL” to “CORE” model. ![]() I started wondering why SQL Server is using the just 20 logical CPUs then I found that we were using enterprise edition with “Server+CAL” licensing model. When I checked the box to know how many CPU the box got, it surprised me because it got 224 logical cores. When I started ramping-up more and more workload on the server, I found the SQL Server was using only 20 CPUs. Yesterday, I was doing SQL Server Database stress and benchmarking testing on the client side. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |