New post SQL Server Diagnostic Information Queries for December 2022
Microsoft Data Platform MVP
YouTube: http://bit.ly/2PkoAM1
Glenn Berry
- 287 Followers
- 90 Following
- 28 Posts
@Aschenbrenner That would depend on the workload. A Samsung 990 PRO will do much better for sequential throughput, but that old Optane will have lower latency and better random perf at low queue depths
leemarkumIf you are part of the #sqlserver community, please go vote on this to get trace flag 3226 enabled by default.
https://feedback.azure.com/d365community/idea/7bfeb6c9-d570-ed11-a81b-000d3adb7ffd
Boosting one more time. Please take a moment and consider upvoting this Azure Feedback item to enable TF 3226 by default in SQL Server. Thanks!
https://feedback.azure.com/d365community/idea/7bfeb6c9-d570-ed11-a81b-000d3adb7ffd
Please take a moment and read and hopefully upvote this Azure Feedback item about making TF 3226 be on by default in future versions of SQL Server. Thanks!
https://feedback.azure.com/d365community/idea/7bfeb6c9-d570-ed11-a81b-000d3adb7ffd
@nikoneugebauer I understand the financial appeal to Intel. But Intel is not in a position of strength vs. AMD Genoa for general purpose compute.
The specialized accelerators in Sapphire Rapids can help offset that, if more ISVs start using them. Trying to charge extra (and confusing people) seems like it will slow adoption.
I think "Intel On Demand" is a huge short-sighted mistake.
Intel has some potentially interesting and useful hardware offload accelerators in Sapphire Rapids.
Doing this will slow adoption of those accelerators.
CPU-Z 2.03.1 is available.
CPU-Z | Softwares | CPUID
CPU-Z for Windows® x86/x64 is a freeware that gathers information on some of the main devices of your system : Processor name and number, codename, process, package, cache levels. Mainboard and chipset. Memory type, size, timings, and module specifications (SPD). Real time measurement of each core's internal frequency, memory frequency. CPU-Z is fully supported on Windows® 11. The CPU-Z‘s detection engine is now available for customized use through the CPUID System Information Development Kit, a professional SDK built for the Microsoft Windows & Android.
@DaveMasonDotMe For years, Intel has had artificial product segmentation in their server SKUs. This on demand stuff just makes it worse...
They would be better off to emulate AMD and reduce the number of SKUs and have most SKUs support all features, period.