user1254579
Reputation: 4009
when to adjust i/o affinity in sql server
what exactly is i/o affinity in SQL server?
An SQ L SERVER uses 64 cores. It has been discovered that a performance issues ,when large amount of data are written to tables under heavy system load.
Why to limit the number of cores that handle I/O by using I/O Affinity?
When to create an affinity mask?
Upvotes: 1
Views: 933
Answers (1)
M.P.
Reputation: 272
It is used to control how many cores of CPU are used for disk operations and how many are used for the remaining SQL related services.
Upvotes: 1
Related Questions
- Is it a good practice to set interrupt affinity and io handling thread affinity to the same core?
- When should we be concerned about Disk I/O?
- Estimating IOPS requirements of a production SQL Server system
- Difference between processor affinity and I/O affinity
- Need some help understanding IO Statistics
- Pros and Cons of CPU affinity
- These days, what are good reasons for setting thread affinity rather than leaving it to the OS?
- Is SQL Server smart enough to not do IO when it is not really needed?
- Prioritizing I/O for a specific query request in SQL server
- when is parallelizing disk i/o worth the effort?