{{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:

Generate Models from SQL Server using Entity Framework Core

To generate models from SQL Server database tables using Entity Framework (EF) in .NET, you can follow the Database-First approach with Ent...