Skip to content

Instantly share code, notes, and snippets.

@bartread
Created January 10, 2017 20:29
Show Gist options
  • Save bartread/50446b6317450351827d32d3d84c05e5 to your computer and use it in GitHub Desktop.
Save bartread/50446b6317450351827d32d3d84c05e5 to your computer and use it in GitHub Desktop.
Get basic SQL Server and OS information
SELECT [cpu_ticks] ,
[ms_ticks] ,
[cpu_count] ,
[hyperthread_ratio] ,
[physical_memory_kb] ,
[virtual_memory_kb] ,
[committed_kb] ,
[committed_target_kb] ,
[visible_target_kb] ,
[stack_size_in_bytes] ,
[os_quantum] ,
[os_error_mode] ,
[os_priority_class] ,
[max_workers_count] ,
[scheduler_count] ,
[scheduler_total_count] ,
[deadlock_monitor_serial_number] ,
[sqlserver_start_time_ms_ticks] ,
[sqlserver_start_time] ,
[affinity_type] ,
[affinity_type_desc] ,
[process_kernel_time_ms] ,
[process_user_time_ms] ,
[time_source] ,
[time_source_desc] ,
[virtual_machine_type] ,
[virtual_machine_type_desc]
FROM [sys].[dm_os_sys_info];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment