when I run the following query from Glenn Berry
-- Hardware information from SQL Server 2016 (Query 18) (Hardware Info) SELECT cpu_count AS [Logical CPU Count], scheduler_count, hyperthread_ratio AS [Hyperthread Ratio], cpu_count/hyperthread_ratio AS [Physical CPU Count], physical_memory_kb/1024 AS [Physical Memory (MB)], committed_kb/1024 AS [Committed Memory (MB)], committed_target_kb/1024 AS [Committed Target Memory (MB)], max_workers_count AS [Max Workers Count], affinity_type_desc AS [Affinity Type], sqlserver_start_time AS [SQL Server Start Time], virtual_machine_type_desc AS [Virtual Machine Type], softnuma_configuration_desc AS [Soft NUMA Configuration], sql_memory_model_desc -- New in SQL Server 2016 SP1 FROM sys.dm_os_sys_info WITH (NOLOCK) OPTION (RECOMPILE); ------
when I use powershell I get more details though:
I have been reluctant to learn powershell, but I plan to accept it soon...
meanwhile, the question is:
Is there any way in sql server to find out the speed of the processor (in this case 2.60 Ghz)?