AMD EPYC Rome

AMD has launched the new generation of their server processor EPYC with the Zen 2 design. It looks really promising, and I look foreward to see some performance figures from the real world.

I will not go into the technical details om the processor, as there are others who already has done that. And far better than I will be able to:

• ars technica: A detailed look at AMD’s new Epyc “Rome” 7nm server CPUs (link)
• ServeTheHome: AMD EPYC 7002 Series Rome Delivers a Knockout (link)
• AnadTech: AMD Rome Second Generation EPYC Review (link)
• Storage Review: AMD EPYC Rome 7002 Series Launched (link)
• tom's hardware: AMD Unveils 7nm EPYC Rome Processors (link)

(2019-10-23)
tom's hardware has the very interesting article "AMD's 64-Core EPYC and Ryzen CPUs Stripped: A Detailed Inside Look" (link).

CPU count from T-SQL

I would like to know the number of processors (cores) on a given computer. No matter what the CPU affinity is or how many database instances is running on the computer.

The answer is given by the DMV "sys.dm_os_schedulers"
SELECT MAX([cpu_id]) + 1 AS [cpu_count]
FROM [master].[sys].[dm_os_schedulers];

I could use WMI and the Win32_Processor class (MSDN Library), but I don't always have the necessary rights to read the value remote.