What are the vector processing(SIMD) operators used in SQL 2016. How does SQL optimizer deal with branch-miss, conditional execution, TLB misses and out of order execution when using InMemory Computing? Is there any tool to check this?
I would suggest using Intel’s Tune for this purpose.
I believe that Microsoft sees no reason for providing any direct insight on those matters, since they can & are being changed regularly.
What are the vector processing(SIMD) operators used in SQL 2016. How does SQL optimizer deal with branch-miss, conditional execution, TLB misses and out of order execution when using InMemory Computing? Is there any tool to check this?
Hi Raju,
I would suggest using Intel’s Tune for this purpose.
I believe that Microsoft sees no reason for providing any direct insight on those matters, since they can & are being changed regularly.
Best regards,
Niko Neugebauer