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

Mysql - java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed

Add allowPublicKeyRetrieval=true to the JDBC URL. jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&useSSL=false