How-To Technical

Query SQL for Version, Edition and Number of CPU’s

The following will give you information about an Microsoft SQL Server instance which you may find helpful in determining the version, edition and number of cpu’s assigned to a SQL server.

In my case I am using Microsoft SQL Server 2014 Express but this will work on all  versions of Microsoft SQL Server


SELECT @@VERSION AS 'SQL Server Version';
SELECT Serverproperty('Edition')
select scheduler_id, cpu_id, status, is_online 
from sys.dm_os_schedulers 
where status = 'VISIBLE ONLINE'

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.