@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

New post SQL Server Diagnostic Information Queries for December 2022

https://bit.ly/3VOXvRn

#sqlserver #sqlserver2022

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

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.

https://www.cpuid.com/softwares/cpu-z.html

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

bit.ly/3gIHWfd

#Samsung #Samsung990

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

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!

Micro Center is selling Ryzen 9 5900X processors for $319.99 and Ryzen 9 3900X processors for $239.99, both of which are killer deals for 12C/24T CPUs.

NewsGator Reader was the classic RSS reader, especially since I was the only DBA for NewsGator

Getting ready to flash the BIOS on an old MSI B450 Tomahawk MAX motherboard that I am selling to someone.

Always fun to see a customer shooting themselves in the foot with scalar-UDFs

SLS/Artemis 1: will pass within about 80 miles of the lunar surface at 7:57am (1257 UTC)

What has been interesting seeing is how much of a social media machine @shanselman is. He joined Mastodon yesterday, and his follwer count is already through the roof. If you've not come across Scott before, that really surprises me as he freely shares programming wisdom and examples. If you haven't followed him yet, you owe it to yourself to do so.

We're still working on dbatools 2.0 but slipped in an update to add full support for SQL Server 2022 in v1.1.143 🥳 As with all dbatools releases, we've included the latest version of Glenn Berry's Diagnostic Scripts which also supports #SQLServer 2022 https://www.powershellgallery.com/packages/dbatools/1.1.143