2019. 10. 17. 15:03
SQL SERVER
declare @max int
select @max = max_workers_count from sys.dm_os_sys_info
select
@max as 'TotalThreads',
sum(active_Workers_count) as 'CurrentThreads',
@max - sum(active_Workers_count) as 'AvailableThreads',
sum(runnable_tasks_count) as 'WorkersWaitingForCpu',
sum(work_queue_count) as 'RequestWaitingForThreads' ,
sum(current_workers_count) as 'AssociatedWorkers'
from
sys.dm_os_Schedulers where status='VISIBLE ONLINE'
https://dba.stackexchange.com/questions/188102/who-is-using-my-worker-threads-sql-server-2014-hadr
'SQL SERVER' 카테고리의 다른 글
| 테이블 반환 함수 (0) | 2019.10.25 |
|---|---|
| DB파일 MDF 사용량 SIZE 확인 (0) | 2019.10.21 |
| linked server를 통한 Oracle Procedure 호출 (0) | 2019.10.01 |
| SQL Server 엔지니에어게 필요한 오라클 Linked Server의 모든것 (0) | 2019.09.24 |
| Oracle Linked Server Fetch Size 설정 (0) | 2019.09.03 |