Събитие
31.03, 23 ч. - 2.04, 23 ч.
Най-голямото събитие за обучение по SQL, Fabric и Power BI. 31 март – 2 април. Използвайте код FABINSIDER, за да спестите $400.
Регистрирайте се днесServer configuration: affinity64 I/O mask
Applies to: 
SQL Server
The affinity64 I/O mask binds SQL Server disk I/O to a specified subset of CPUs, similar to the affinity I/O mask option. Use affinity I/O mask to bind the first 32 processors, and use affinity64 I/O mask to bind the remaining processors on the computer. If you reconfigure the affinity64 I/O mask, you must restart the instance of SQL Server. This option is only visible on the 64-bit version of SQL Server.
Допълнителни ресурси
Обучение
Модул
Configure SQL Server resources for optimal performance - Training
Configure SQL Server resources for optimal performance
Документация
-
Correct affinity mask & affinity IO mask overlap policy - SQL Server
Learn how to enable a policy that checks whether an instance of SQL Server has one ore more processors that are assigned to be used with both the affinity mask and the affinity I/O mask options for Policy-Based Management in SQL Server.
-
Server configuration: ADR cleaner retry timeout (min) - SQL Server
Explains the SQL Server instance configuration setting for ADR cleaner retry timeout.
-
Server properties (processors page) - SQL Server
Get acquainted with processor settings in SQL Server. Learn which options control the number of worker threads, the processor assignment, and other properties.