top of page

Script to find SQL Server Hardware Details

Writer: Kunal RanpuraKunal Ranpura

SELECT cpu_count AS [Logical CPU Count], hyperthread_ratio AS [Hyperthread Ratio],

cpu_count/hyperthread_ratio AS [Physical CPU Count],

physical_memory_kb/1048576 AS [Physical Memory (MB)],

sqlserver_start_time, affinity_type_desc

FROM sys.dm_os_sys_info OPTION (RECOMPILE);


--Fetching data from SQL Server DMV sys.dm_os_sys_info

Recent Posts

See All

SQL Server Profiler Trace

--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...

Find All Primary Key in SQL Server

select schema_name(tab.schema_id) as [schema_name], pk.[name] as pk_name, substring(column_names, 1, len(column_names)-1) as [columns],...

Comments


bottom of page