Shulou(Shulou.com)05/31 Report--

Editor to share with you what sql server2012 pit, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to understand it!

In the past, there was no cpu restriction on the Key of sql server database. As a result, there was such a restriction in version 2012. Unfortunately, I stepped into the pit.

In a system, the concurrency is relatively large, and the database often lives in hang, but the utilization rate of cpu is only about 60, not more than 65%. The operating system response is very normal. Check the usage of cpu, 32 cpu, only 20 are full load, and the rest are very idle. It can only be alleviated by restarting the database instance, but the production cannot do so. Always feel very strange, but do not know why, and then check each link and cpu-related parameters, 32 cpu are bound, can be used. Finally, there is no way to restart the instance of sql server again. At this time, I took a closer look at the log and recorded such a paragraph in the startup log to know the reason:

SQL Server detected 1 sockets with 32 cores per socket and 32 logical processors per socket, 32 total logical processors; using 20 logical processors based on SQL Server licensing. This is an informational message; no user action is required.

Oh, my God, I really fell into the pit. I haven't heard of such a situation after using sql server for so long. Later, I consulted Microsoft, and Microsoft said that 2012 had changed. Completely dizzy, find the right version of key and upgrade

MICROSOFT SQL SERVER 2012 Enterprise Core Activation Code Serial number: FH666-Y346V-7XFQ3-V69JM-RHW28

MICROSOFT SQL SERVER 2012 Business Intelligence Edition Activation Code Serial number: HRV7T-DVTM4-V6XG8-P36T4-MRYT6

MICROSOFT SQL SERVER 2012 Development Edition Activation Code Serial number: YQWTX-G8T4R-QW4XX-BVH62-GP68Y

MICROSOFT SQL SERVER 2012 Enterprise Server Edition / CAL Edition Serial number: 748RB-X4T6B-MRM7V-RTVFF-CHC8H

MICROSOFT SQL SERVER 2012 Standard Activation Code Serial number: YFC4R-BRRWB-TVP9Y-6WJQ9-MCJQ7

MICROSOFT SQL SERVER version 2012 WEB Activation Code Serial number: FB3W8-YRXDP-G8F8F-C46KG-Q998F

There is no cpu limit for the serial number of the first line, while there is a cpu limit for the fourth line of enterprise.

Do not know why, immediately make up your mind, re-register key, restart the instance, the database can use all cpu!

The above is all the contents of this article "what's wrong with sql server2012?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.