{{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 Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...