Modifica di Macchina MSSQL Server (sezione)

== Licenza ==
* '''CAL (5 utenti)''' <p><code>FG86G-CHH2T-CB7NJ-XT7D2-V8V4X</code><br/>
Acquistata da [https://macrosoft.store/it/ MACROSOFT] con l'account di Cerutty.<br/>
Non la usiamo più, ha il limite degli utenti.</p>
* '''Standard 16 Core''' <p><code>BDJ3K-DRFGP-CNVTG-QHK7F-FC6B6</code><br/>
Acquistata da [https://lalicenza.it LALICENZA] con l'account di Vinci (<span style="font-family:monospace;font-size:0.7rem">s.vincenzi@webmobili.it - W3bm0b1l!</span>).</p>
Per verificare i '''core''' visibili ed effettivamente assegnati, usare
<syntaxhighlight lang="sql>
SELECT scheduler_id, cpu_id, status, is_online FROM sys.dm_os_schedulers 
GO
</syntaxhighlight>

Altro script che fa un check di quelle utilizzabili.
<syntaxhighlight lang="sql">
----------------------------------------------------------------------------------------------------------------
-- CPU VISIBLE ONLINE CHECK
----------------------------------------------------------------------------------------------------------------
DECLARE @OnlineCpuCount int
DECLARE @LogicalCpuCount int

SELECT @OnlineCpuCount = COUNT(*) FROM sys.dm_os_schedulers WHERE status = 'VISIBLE ONLINE'
SELECT @LogicalCpuCount = cpu_count FROM sys.dm_os_sys_info 

SELECT @LogicalCpuCount AS 'ASSIGNED ONLINE CPU #', @OnlineCpuCount AS 'VISIBLE ONLINE CPU #',
   CASE 
     WHEN @OnlineCpuCount < @LogicalCpuCount 
     THEN 'You are not using all CPU assigned to O/S! If it is VM, review your VM configuration to make sure you are not maxout Socket'
     ELSE 'You are using all CPUs assigned to O/S. GOOD!' 
   END as 'CPU Usage Desc'
----------------------------------------------------------------------------------------------------------------
GO
</syntaxhighlight>