Scalegrid

JULY 13, 2020

Compare PostgreSQL vs. Oracle functionality across available tools, capabilities and services. Compare ease of use across compatibility, extensions, tuning, operating systems, languages and support providers. Not available. Not available. Not available. Compare Functionality. Compare Ease of Use. Total Cost. $0.

Open Source 244

Open Source Tuning C++ Database 244

SQL Performance

JANUARY 23, 2020

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006. Query Store 2017 to the Rescue.

Tuning 115

Tuning Servers Monitoring Hardware 115

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

SEPTEMBER 25, 2021

As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. Theory (A) is most likely based on the frame widths in the flame graph. But I'm not completely sure.

Speed 126

Speed Java AWS Virtualization 126

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. The parallel column store aggregate push down result of 57 million rows processed in 7ms (using 40ms of CPU) is remarkable, especially considering the hardware. Final Thoughts.

Servers 86

Servers Tuning Database Efficiency 86

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. This means that multiple partitions can be processed simultaneously, making better use of available hardware resources and further enhancing query performance. This helps identify potential issues and fine-tune the partitioning strategy.

Strategy 40

Strategy Storage Database Best Practices 40

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. Here is a summary of the queries: Simple queries: select count(*) from ontime where flightdate > '2017-01-01'. With faster disks (i.e. AWS Aurora (based on MySQL 5.6)

Cache 46

Cache C++ AWS Airlines 46