February 28, 2016 at 3:32 am
Hi
Ask help from old-hands
We have a server : win 2008 R2 enterprise (virtual machine) - Sql server 2014 - sp1
we had 22 cpu core which all of them used almot equal by sql server.
we asked 8 more core for our server. and thay gave them .
But almots these new cores are in zero used (by monitoring task manager)
what is the resone?
thank you
February 28, 2016 at 7:54 am
MotivateMan1394 (2/28/2016)
HiAsk help from old-hands
We have a server : win 2008 R2 enterprise (virtual machine) - Sql server 2014 - sp1
we had 22 cpu core which all of them used almot equal by sql server.
we asked 8 more core for our server. and thay gave them .
But almots these new cores are in zero used (by monitoring task manager)
what is the resone?
thank you
Quick questions, what is the output of
SELECT @@VERSION?
How are the cores mapped? Is each core mapped to a vCPU?
😎
February 29, 2016 at 10:16 pm
Microsoft SQL Server 2014 - 12.0.4100.1 (X64)
Apr 20 2015 17:29:27
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
March 1, 2016 at 10:06 am
What is the result of this query on your server?
SELECT scheduler_id,
cpu_id,
status
FROM sys.dm_os_schedulers
WHERE status LIKE 'VISIBLE%';
Also, in the SQL Server log, when the instance starts up there will be a message that says how many cores were detected. What is the full text of that entry?
Cheers!
March 2, 2016 at 1:10 am
Thank you for your attention . 🙂
and these are the data which you wanted :
scheduler_idcpu_idstatus
00VISIBLE ONLINE
11VISIBLE ONLINE
22VISIBLE ONLINE
33VISIBLE ONLINE
44VISIBLE ONLINE
55VISIBLE ONLINE
66VISIBLE ONLINE
77VISIBLE ONLINE
88VISIBLE ONLINE
99VISIBLE ONLINE
1010VISIBLE ONLINE
1111VISIBLE ONLINE
1212VISIBLE ONLINE
1313VISIBLE ONLINE
1414VISIBLE ONLINE
1515VISIBLE ONLINE
1616VISIBLE ONLINE
1717VISIBLE ONLINE
1818VISIBLE ONLINE
1919VISIBLE ONLINE
2020VISIBLE OFFLINE
2121VISIBLE OFFLINE
2222VISIBLE OFFLINE
2323VISIBLE OFFLINE
2424VISIBLE OFFLINE
2525VISIBLE OFFLINE
2626VISIBLE OFFLINE
2727VISIBLE OFFLINE
2828VISIBLE OFFLINE
2929VISIBLE OFFLINE
10485760VISIBLE ONLINE (DAC)
-------------------------------------------
Message
SQL Server detected 5 sockets with 6 cores per socket and 6 logical processors per socket, 30 total logical processors; using 20 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
!!! very interesting information :w00t::w00t::w00t:
And what do I do ?
March 2, 2016 at 1:23 am
MotivateMan1394 (3/2/2016)
using 20 logical processors based on SQL Server licensing.
There's your answered. You are licensed to use max 20 cores. Seems you are using the Server/CAL based licensing method and not the core-based licensing method.
See http://blog.sqlauthority.com/2015/05/29/sql-server-using-20-logical-processors-based-on-sql-server-licensing/[/url] for more information.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply