Glenn Berry

287 Followers
90 Following
28 Posts
Services Database Engineer
Microsoft Data Platform MVP
YouTube: http://bit.ly/2PkoAM1

New post SQL Server Diagnostic Information Queries for December 2022

https://bit.ly/3VOXvRn

#sqlserver #sqlserver2022

SQL Server Diagnostic Information Queries for December 2022

Introduction These are my SQL Server Diagnostic Information Queries for December 2022, aka my DMV Diagnostic

Glenn's SQL Server Performance

If 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

Community

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

Community

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

Community

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 | 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.

New blog post: Is the Samsung 990 PRO Any Good?

bit.ly/3gIHWfd

#Samsung #Samsung990

More updates for the SQL Server 2022 version of my SQL Server Diagnostic Information Queries.

glennsqlperformance.com/resources/

#SQLServer #sqlserver2022

Hoo boy! Someone at Intel thinks this is a good idea?

https://www.intel.com/content/www/us/en/products/docs/ondemand/overview.html

I finally have a 2TB Samsung 990 PRO SSD arriving tomorrow. That will be fun to play with!