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. Your NUMA system may not have different processor groups for each node. No user action is required.

Servers 45

Servers Virtualization Scalability Hardware 45

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. For the more adventurous/technical, the top (table of processes) command provides similar metrics on most Unix-like operating systems such as macOS and Ubuntu. These include data transfer (i.e.

Website Performance 73

Website Performance Website Energy Performance 73

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

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. root@ip-172-31-128-38 share]# cat /usr/lib/systemd/system/mysqld@.service AFAIK Facebook does this. Version: '8.0.19-10'

Programming 84

Programming Servers Database Hardware 84

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. I always check backups first when looking at a new system. 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.

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. Q: Is there a plan to support more operating systems? 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.

Network 157

Network Monitoring Servers Hardware 157

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

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.” – [link]. The Back Story.

Servers 90

Servers Media Cache Storage 90

Alex Russell

APRIL 29, 2021

After 20 years of neck-in-neck competition, often starting from common code lineages, there just isn't that much left to wring out of the system. Consistent improvement is the name of the game, and it can still have positive impacts, particularly as users lean on the system more heavily over time. Some relatively minor additions (e.g.

Media 145

Media Games Education Engineering 145

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

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