r/sysadmin•
vPock

SQL Standard compute maximums

(I also posted on r/sqlserver)

Hello,

So I was reading this and it states that the compute maximums for SQL Server Standard are 4 sockets and 24 cores.

But this states the maximum as 24 cores periods, and looks more recent (SP1).

So, which was is right regarding the compute maximums of SQL Server Standard SP1? 24 cores or 24 cores with a maximum of 4 sockets?

Thanks!

Posted Mar 10, 2017, 8:54 PM UTC

11
motoxrdr21Jack of All Trades•

Your first link directly references SP1, the legend on that table says the callout for 2 "Applies to SQL Server 2016 SP1." so it has also been updated for the features added with SP1.

I would trust the more detailed first link, look outside of Standard Edt. and you'll see that Exp, Exp w/ Adv, & Web all have the same discrepancy between the summarized and detailed information.

1