If you have an ODBC application that is connecting to a mirrored database and if
The application uses a connection string without a database name ( for e.g: dsn=ssistest;uid=ssistest;pwd=*********)
The DSN is configured to use SQL authentication...

The SQL Books Online states that using NUMA port affinity helps co-locate the resources used by the query (CPU, Memory, ….). This is true for serial plan execution but not completely the case for parallel query execution. You might assume that you can...