SQL Server According to Bob

NOVEMBER 29, 2016

Back in June, Bob Dorr gave you the thinking behind why SQL Server 2016 It Just Runs Faster due to changes in our SQL Server and NUMA configurations. Bob blogged about a new SQL Server 2016 feature called Auto Soft NUMA. Windows Server 2016 supports up to 240 vCPUs per VM). And the node mapping has apparently gone crazy.

Servers 45

Servers Virtualization Scalability Hardware 45

Rigor

MARCH 20, 2018

I wrote a blog in 2016 that discussed the need for businesses to flip the traditional monitoring investment pyramid on its head. Instead of focusing on hardware and infrastructure first, technical teams should first ensure that they first have visibility on the thing that drives the business: their customer experience.

Monitoring 40

Monitoring Retail Ecommerce Infrastructure 40

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Smashing Magazine

JANUARY 15, 2019

how much data does the browser have to download to display your website) and resource usage of the hardware serving and receiving the website. In 2016, O’Reilly published “ Designing For Sustainability ” by Tim Frick. I have written a blog post about rolling your own carbon offset scheme. These include data transfer (i.e.

Website Performance 73

Website Performance Website Energy Performance 73

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability 40

Availability Servers Hardware Benchmarking 40

Brendan Gregg

NOVEMBER 29, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance. I'd expect between 0.1%

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Performance

JUNE 21, 2019

I wrote a blog about it years ago too, however as time has marched on, guidance has changed a bit. Jonathan Kehayias has written an blog post How much memory does my SQL Server actually need , with a formula that helps establish the baseline for the maximum memory value. SQL Server 2016 introduced soft-NUMA nodes.

Servers 49

Servers Azure Hardware Database 49

Dynatrace

JUNE 7, 2019

For detailed prerequisites, hardware requirements, and installation guidelines, see our help page for browser monitors in private locations. LTS, Red Hat server 7 and CentOS server 7 for the execution of private browser monitors; Windows Server 2016 support is coming soon as well. Q: Is there a plan to support more operating systems?

Network 160

Network Monitoring Servers Hardware 160

Percona

AUGUST 18, 2023

This blog describes how to configure systemd for multiple instances of MySQL. The original motivation for FB was due to different hardware generations, especially between regions/data centers. Here, we will configure multiple MySQL instances from the generic binaries and manage them using systemd. AFAIK Facebook does this.

Programming 84

Programming Servers Database Hardware 84

Alex Russell

FEBRUARY 21, 2023

The size of the release was expected in some corners, owing to the torrent of WebKit blog posts over the last few weeks: Jan. The phrase "stop-energy" is often misused, but the dampening effect of Apple on the progress of Web Components after 2015-2016's burst of V1 design energy was palpable. 31st : Web Share changes Feb.

Energy 79

Energy Games Engineering Design 79

Brendan Gregg

NOVEMBER 28, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance. I'd expect between 0.1%

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers 46

Servers Hardware Architecture Retail 46

Brendan Gregg

SEPTEMBER 5, 2017

LTS (April 2016). I wrote about it in a previous post, [DTrace for Linux 2016]. I wrote a page on it: [perf]. - **eBPF**: tracing features completed in 2016, this provides efficient programmatic tracing to existing kernel frameworks. The hardest part on Linux is now done: kernel support. It's the official profiler.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Alex Russell

APRIL 29, 2021

At the time of the last Confluence run, the gap had stretched to nearly 1000 APIs, doubling since 2016. is access to hardware devices. This allows customisation and use of specialised features without custom, proprietary software for niche hardware. Some commenters appear to confuse unlike hardware for differences in software.

Media 145

Media Games Education Engineering 145

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. The queries are similar to those I’ve used in older blog posts comparing MySQL and Apache Spark performance ( [link] ). With faster disks (i.e. AWS Aurora (based on MySQL 5.6) sec). /* another run */.

Cache 46

Cache C++ AWS Airlines 46

SQL Server According to Bob

DECEMBER 18, 2018

Linux may need similar utilities to control various hardware cache installations. You should always validate the Fua capabilities with your device and hardware vendor. To accommodate a wide range of installations and hardware required four (4) options across SQL Server and the HE. Fua = Forced Unit Access. Device Flush.

Servers 90

Servers Media Cache Storage 90