3 ms·
One thing I really want to know is whether SQL Server's new vector-accelerated "Batch Mode" uses AVX2 only or if it also has AVX-512 code paths? I'd like to be
by jiggawatts 6y ago
One thing I really want to know is whether SQL Server's new vector-accelerated "Batch Mode" uses AVX2 only or if it also has AVX-512 code paths?
I'd like to be able to recommend the right CPU to customers, but there just isn't any information out in public about this...
- rbanffy 6y agoThere are a lot of different factors that can affect performance. I'd advise you to always benchmark.
- jiggawatts 6y agoI can't benchmark with a CPU I don't have, and I can't advise a customer to go off and buy a $50K server just for a "quick benchmark". Even if I were to, say, test with some cloud VMs, even then there are confounding issues. The different VM size categories aren't just different in the CPU type only, there are other differences that'll make the benchmark difficult to interpret. Memory type, throttling, HT on/off, etc... Why is it so difficult for Microsoft to simply say "AVX-512 supported" somewhere in their documentation? This is like every TV vendor saying "HDMI" instead of "HDMI 2.1" or whatever. Just because the port looks the same doesn't mean that they're identical! Versions matter.
- rbanffy 6y ago"AVX-512 supported" doesn't say much either. They used to publish reference designs with specific servers and components.
- gameswithgo 6y agoyou could rent an avx-512 vm in the cloud for a few hours?
- foota 6y agoThis is a terrible suggestion, but you could always attach a debugger to find out
- fluffything 6y agoOr just disassemble the binary and grep for avx-512 or avx2 instructions ? Or if SQL server is open source, just go to their github/gitlab/whatever repo, and enter the name of a commonly-used avx512 intrinsic on the search field ?
- foota 6y agoI figured it would be easier to find the specific area by debugging than disassembling, since it's likely easily tens to hundreds of megs. Also, SQL server is definitely not open source lmao.
- dragontamer 6y ago> This is a terrible suggestion Well, if we're optimizing a terrible idea anyway... https://download.01.org/perfmon/index/skylake_server.html https://download.01.org/perfmon/index/skylake_server.html The FP_ARITH_INST_RETIRED.512B_PACKED_SINGLE performance counter _seems_ to be the hardware performance counter tracking AVX512-32-bit instructions. You wouldn't even need a debugger. Just a reset: turn on hardware performance counters in the BIOS and run a profiler that can read the hardware performance counters. I don't know if that's the performance counter for sure that we're looking for. There's a few other 512B counters there.