Home Forums SQL Server 2014 Administration - SQL Server 2014 Error: 18056, Severity: 20, State: 29. RE: Error: 18056, Severity: 20, State: 29.
kvishu83
SSC Eights!
Points: 848
More actions
December 1, 2016 at 12:04 pm
#1915544
MAX DOP : 6
Cost Threshold for Parallelism: 15
select * from sys.dm_os_wait_stats where wait_type = 'threadpool';
wait_typewaiting_tasks_countwait_time_msmax_wait_time_mssignal_wait_time_ms
THREADPOOL303468614170