如何让SQL 2012 Enterprises超过40 core
1、查询当前SQL版本可使用的core数量:
查询全部core:SELECT COUNT(1) FROM SYS.DM_OS_SCHEDULERS WHERE SCHEDULER_ID<255
查询全部core:SELECT COUNT(1) FROM SYS.DM_OS_SCHEDULERS WHERE SCHEDULER_ID<255
查询可使用core:SELECT COUNT(1) FROM SYS.DM_OS_SCHEDULERS WHERE SCHEDULER_ID<255 AND IS_ONLINE=1
2、使Microsoft SQL Server 2012 Enterprise Edition (64-bit)升级到Microsoft SQL Server 2012 Enterprise CORE Edition (64-bit)版本
2、使Microsoft SQL Server 2012 Enterprise Edition (64-bit)升级到Microsoft SQL Server 2012 Enterprise CORE Edition (64-bit)版本
![](https://img2020.cnblogs.com/blog/2682776/202112/2682776-20211213171208177-415967810.png)