{{theTime}}

Search This Blog

Total Pageviews

Processor Affinity and I/O Affinity setup in Sql server.

To implement multitasking, sometimes the servers move process threads among different processors.  Assigning processors to specific threads can improve performance, by eliminating processor reloads and reducing thread migration across all processors, such an association between thread a processor is called processor affinity.

Go to Server properties in MSSql server to setup.


No comments:

AI Predictive Bot - Scenario Model

  💡 How to Read the Costco Scenario Model This simulator bridges the gap between how a company operates (its business performance) and how...