Percona

MARCH 30, 2023

Further, open source databases can be modified in infinite ways, enabling institutions to meet their specific needs for data storage, retrieval, and processing. Non-relational databases: Instead of tables, non-relational (NoSQL) databases use document-based data storage, column-oriented storage, and graph databases.

Open Source 107

Open Source Database Storage Scalability 107

SQL Performance

SEPTEMBER 5, 2019

This table uses columnstore for its primary storage to produce batch mode execution later on. You can skip the WHERE clauses if you are running SQL Server 2017. OPTION ( MAXDOP 1 ) ; This time, only the COUNT_BIG aggregate achieves aggregate pushdown (SQL Server 2017 only). Batch mode execution is all about speed.

Performance 81

Performance C++ Storage Servers 81

Brendan Gregg

JULY 4, 2021

AWS Graviton2); for memory with the arrival of DDR5 and High Bandwidth Memory (HBM) on-processor; for storage including new uses for 3D Xpoint as a 3D NAND accelerator; for networking with the rise of QUIC and eXpress Data Path (XDP); and so on. Ford, et al., “TCP

Performance 52

Performance Latency Hardware Storage 52

SQL Performance

FEBRUARY 3, 2020

Applying page or row compression (both online/offline) to the source before the affinitized copy (offline), to see if compressing the data first could speed up the destination. The downside to the latter is that, in SQL Server 2017, you cannot run this online… but you will be able to in 2019.

Speed 113

Speed Processing Servers Storage 113

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Depending on the database size and on disk speed, a backup/restore process might take hours or even days! Depending on the database size and on disk speed, a backup/restore process might take hours or even days!

Best Practices 98

Best Practices Traffic Database Servers 98

Brendan Gregg

FEBRUARY 28, 2023

References I've reproduced the references from my SREcon22 keynote below, so you can click on links: [Gregg 08] Brendan Gregg, “ZFS L2ARC,” [link] , Jul 2008 [Gregg 10] Brendan Gregg, “Visualizations for Performance Analysis (and More),” [link] , 2010 [Greenberg 11] Marc Greenberg, “DDR4: Double the speed, double the latency?

Performance 52

Performance Latency Cache Virtualization 52

SQL Performance

MARCH 17, 2020

It comes set to SQL Server 2008 compatibility (level 100), but we will start with a more modern setting of SQL Server 2017 (level 140): ALTER DATABASE StackOverflow2013 SET COMPATIBILITY_LEVEL = 140 ; The tests were performed on my laptop using SQL Server 2019 CU 2. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

AUGUST 27, 2019

TPC-H Benchmark Results with SQL Server 2017. HPE has already submitted a new official TPC-H result on SQL Server 2017 for a single-socket, HPE Proliant DL325 Gen10 1U server that was 743,750 QphH@1000GB. TPC-E Benchmark Results with SQL Server 2017. Higher memory speed and bandwidth. Higher memory density/capacity.

Servers 52

Servers Benchmarking Virtualization Architecture 52

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. This processor has a base clock speed of 2.0GHz, with an all-core boost speed of 2.55GHz, and a max boost clock speed of 3.0GHz. The L3 cache size is 64MB.

Azure 42

Azure Virtualization Storage Benchmarking 42

Enprowess

JANUARY 12, 2022

Web development is evolving at a rapid speed with each passing year. And so, it optimizes the page loading speed and reduces the bounce rate. So it is convenient for all to use irrespective of internet speed and it works offline using cached data. Twitter Lite PWA : It was integrated as the standard User Interface in 2017.

Blockchain 59

Blockchain IoT Development Serverless 59

Alex Russell

OCTOBER 22, 2017

— Alex Russell (@slightlylate) October 4, 2017. JavaScript is the single most expensive part of any page in ways that are a function of both network capacity and device speed. Thankfully, this is somewhat easier than network speeds: more than half of American mobile users are on Android devices. Global Ground-Truth.

Performance 74

Performance Network Benchmarking Mobile 74

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. Each partition holds data that falls within a specific range, optimizing data handling and query speed. So, What is MySQL Partitioning?

Strategy 40

Strategy Storage Database Best Practices 40

The Morning Paper

JANUARY 19, 2020

STELLA: report from the SNAFU-catchers workshop on coping with complexity , Woods 2017, Coping with Complexity workshop. Today’s choice is a report from a 2017 workshop convened with that title, and recommended to me by John Allspaw – thank you John! Take a trivial example with three components A, B, and C.

C++ 50

C++ Systems Software Software 50

Tasktop

JUNE 25, 2020

When I joined Tasktop back in October of 2017, Tasktop was doing really well. Flow Fabric feeds a schemaless immutable storage of digital artifacts, across disciplines and functions. In the grand tradition of our sages, I’ve been contemplating existential questions about Tasktop and wrote a Bar Mitzvah speech of my own. . And it has.

Metrics 52

Metrics Education Innovation Software 52

Brendan Gregg

NOVEMBER 29, 2017

Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds. In this configuration, the AMI and boot is paravirt (PV), the kernel is making hypercalls instead of privileged instructions, and the system is using paravirt network and storage drivers. I'd expect between 0.1% The AMI and boot are now HVM.

Virtualization 110

Virtualization AWS Hardware Storage 110

SQL Server According to Bob

DECEMBER 31, 2018

Using SQL Server Management Studio (SSMS) and storing the events in a table requires reading the events, streaming to table storage followed by an order by event sequence query. Large traces can encounter the 32-bit SSMS memory limitations. The XEProfiler Sample. Creates an empty DataGrid control. Sorts the EventLocators.

Efficiency 40

Efficiency Code Servers Cache 40

Brendan Gregg

NOVEMBER 28, 2017

Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds. In this configuration, the AMI and boot is paravirt (PV), the kernel is making hypercalls instead of privileged instructions, and the system is using paravirt network and storage drivers. I'd expect between 0.1% The AMI and boot are now HVM.

Virtualization 40

Virtualization AWS Hardware Storage 40

Smashing Magazine

JANUARY 7, 2019

You need a business stakeholder buy-in, and to get it, you need to establish a case study on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. Note : If you use Page Speed Insights (no, it isn’t deprecated), you can get CrUX performance data for specific pages instead of just the aggregates.

Performance 111

Performance Cache Network Metrics 111