--CPU相关视图 SELECT * FROM sys.dm_os_sys_info SELECT * FROM sys.dm_exec_sessions SELECT * FROM sys.sysprocesses SELECT * FROM sys.dm_os_tasks SELECT * FROM sys.dm_os_workers SELECT * FROM sys.dm_os_threads SELECT * FROM sys.dm_os_schedulers SELECT * FROM sys.dm_os_memory_objects SELECT * FROM sys.dm_os_nodes SELECT * FROM sys.dm_os_memory_nodes exec sp_configure 'max degree of parallelism'--系统默认并行度 exec sp_configure 'cost threshold for parallelism' --并发阈值 exec sp_configure 'max worker threads'--系统最大工作线程数 exec sp_configure 'affinity mask' --CPU关联 --数据库系统 cpu,线程 数量 select max_workers_count,scheduler_count,cpu_count,hyperthread_ratio ,(hyperthread_ratio/cpu_count) AS physical_cpu_count ,(max_workers_count/scheduler_count) AS workers_per_scheduler_limit from sys.dm_os_sys_info --执行的线程所遇到的所有等待的相关信息 SELECT TOP 10 wait_type,waiting_tasks_count,signal_wait_time_ms FROM sys.dm_os_wait_stats ORDER BY signal_wait_time_ms DESC --正在等待某些资源的任务的等待队列的信息 SELECT TOP 10 wait_type,wait_duration_ms,session_id,blocking_session_id FROM sys.dm_os_waiting_tasks ORDER BY wait_duration_ms DESC --CPU或调度器当前分配的工作情况 SELECT scheduler_id,cpu_id,status,is_idle ,current_tasks_count AS 当前任务数 --在等待或运行的任务 ,runnable_tasks_count AS 等待调度线程数 --已分配