when to adjust i/o affinity in sql server -


What is the actual / o affair in SQL Server?

Uses a SQL Server 64 Core It has been found that one display related problems when large amounts of data are loaded in bulk.

Why use the I / O affinity to limit the number of cores that I / O handles?

How many CPUs are used to control this? Used for disk operation and how many uses are used for remaining SQL related services.

->


Comments