0

If I have two servers (server A and server B) that are part of the same Availability Group failover cluster, and a query running on server A has an execution plan that uses parallelization, is it possible for that query to use cores from a processor on server B?

6

No, execution plan parallelization refers to using multiple cores on the server executing the query. Parallelize plans are not executed across availability group replicas.

  • Thanks! Clear and concise, unfortunately not the answer I was hoping for. ;) – J.D. Mar 21 at 0:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.