Saturday, August 7, 2021

SQL Socket & Core information

This post will show you how to find out the **socket, physical core, and logical core counts** directly from your **SQL Server Error log**. This information is crucial for verifying your SQL Server licensing model.

EXEC sys.xp_readerrorlog 0, 1, N'detected', N'socket';

Running the command above helps you quickly confirm your SQL Server's configuration and ensure it aligns with your licensing.

Popular Posts