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

Best Client Optimized Programming Language for Mobile Development?

Use Google's Dart language, which is Object-oriented, class-based and garbage-collected language with C-Style.  Dart can compile to eith...