SQL Server According to Bob

SEPTEMBER 26, 2016

Performance issues surrounding Availability Groups typically were related to disk I/O or network speeds. We needed to start thinking about how fast can we replicate to a synchronous secondary replica in terms of % of the speed of a standalone workload. Direct seeding of new database replicas. . one without a replica).

Availability 40

Availability Servers Hardware Benchmarking 40

Percona

FEBRUARY 2, 2023

Recall that logical replication works by using the PUB/SUB mode, where individual tables are published and are then subscribed by remotely connected databases/tables. The good news is that there are hacks that can speed up the entire recovery process, although they all have their own quirky limitations.

Games 93

Games Open Source Tuning Speed 93

SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49

Servers Azure Hardware Database 49

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. In 2016, Jio swept over the subcontinent like a monsoon dropping a torrent of 4G infrastructure and free data rather than rain.

Performance 124

Performance Network Cache Metrics 124

Brendan Gregg

NOVEMBER 29, 2017

Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. This was initially used via the ixgbe driver for speeds up to 10 Gbps, then the ena driver for speeds up to 25 Gbps. The first was c3.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Performance

JULY 16, 2019

From 2007 until 2016, Intel was able to successfully execute their Tick-Tock release strategy, where they would introduce a new processor microarchitecture roughly every two years (a Tock release). 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

Smashing Magazine

OCTOBER 26, 2018

It’s an all-in-one system that is equipped with a working admin interface; it manages database connection, and has a bunch of useful APIs exposed that handle user authentication, routing, and more. on December 6th, 2016. Transients API is used to store data in the options table of your WordPress database for a specific period of time.

Cache 78

Cache Website Speed Database 78

SQL Performance

APRIL 8, 2019

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. Both of these Intel processors are special bespoke models that are not in the Intel ARK database. The L3 cache size is 64MB. lanes for I/O connectivity. The L3 cache size is 64MB.

Azure 42

Azure Virtualization Storage Benchmarking 42

Brendan Gregg

NOVEMBER 28, 2017

Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. This was initially used via the ixgbe driver for speeds up to 10 Gbps, then the ena driver for speeds up to 25 Gbps. The first was c3.

Virtualization 40

Virtualization AWS Hardware Storage 40

Alex Russell

MAY 9, 2022

Some prior art was brought to my attention by people who reviewed earlier drafts of this post; notably this 2021 post by the Splunk team and the following tweet by the NCC Group from 2016 (as well as a related PowerPoint presentation ): NCC Group Web Perf @NCCGroupWebperf Where are you on the #webperf maturity model?

Performance 86

Performance Latency Metrics Engineering 86

The Symphonia

DECEMBER 6, 2017

That means that 3GB functions might not see a linear speed bump for primarily single threaded functions. Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. There have been some improvements since re:Invent 2016 but to see nothing announced at this re:Invent was very disappointing.

Serverless 40

Serverless Lambda AWS Traffic 40

Smashing Magazine

JANUARY 21, 2019

Following, the API will add the database object data. This information is not placed under each module, but under a shared section called databases , to avoid duplicating information when two or more different modules fetch the same objects from the database. In other words, database object data is normalized.

Social Media 64

Social Media Database Media Website 64