DEFINITIONS

Definitions More Info.
Definition ID29
TitleSQL
CategoryNOTES
DefinitionMaximum Worker Threads
Definition Descriptionhttps://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option?view=sql-server-2017

Kaynak: Microsoft Sql Server 2005-2008 Perfoemance Tunning Book S.28

Number of CPUs 32-bit computer 64-bit computer
<=4 256 512
8 processors 288 576
16 processors 352 704
32 processors 480 960
64 processors 736 1472
128 processors 4224 4480
256 processors 8320 8576
-------------------------------------------------------------
-------------------------------------------------------------
X86 lar icin olan hesaplamalar

- 256 number of threads Maximum worker threads = (256 + ((processors) -4) * 8)

Number of CPUs 32-bit computer 64-bit computer
==================================================================================================================
<= 4 processors 256 512

> 4 processors and < 64 processors 256 + ((logical CPU's - 4) * 8) 512 + ((logical CPU's - 4) * 16)

> 64 processors 256 + ((logical CPU's - 4) * 32) 512 + ((logical CPU's - 4) * 32)
RecordBycunay
Record Date02-02-2012 23:03:41
Düzenle
Kopyala
Sil