Are You Using All Your CPU Cores
We recently worked on a SQL Server Performance Assessment for a client and during that we assisted with the upgrade from SQL Server standard edition to SQL Server enterprise edition. Part of the upgrade was an attempt to make use of more cores on the server. They were using Standard Edition of SQL Server which was fully utilizing 48 cores …