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

Brendan Gregg

NOVEMBER 28, 2017

Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds. It's all a bit confusing, and I wrote about this in 2014: [Xen Modes]. When I joined Netflix in 2014, we had begun transitioning from PV to HVM (PVHVM). I'd expect between 0.1% This recommendation quickly became out of date.

Virtualization 40

Virtualization AWS Hardware Storage 40

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

SQL Server According to Bob

SEPTEMBER 26, 2016

Performance issues surrounding Availability Groups typically were related to disk I/O or network speeds. As we moved towards SQL Server 2014, the pace of hardware accelerated. 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.

Availability 40

Availability Servers Hardware Benchmarking 40

SQL Performance

JULY 16, 2019

This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile. So far, we don't know the official base and turbo clock speeds, but there was a recent leak of partial specifications and pricing by a European retailer that listed max boost clock speeds of up to 3.4

Servers 46

Servers Hardware Architecture Retail 46

Alex Russell

MARCH 6, 2021

Devices and networks have evolved too: Alex Russell @slightlylate An update on mobile CPUs and the Performance Inequality Gap: Mid-tier Android devices (~$300) now get the single-core performance of a 2014 iPhone and the multi-core perf of a 2015 iPhone. Recall that single-core performance most directly translates into speed on the web.

Performance 124

Performance Network Cache Metrics 124

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo.

Servers 95

Servers Tuning Architecture Processing 95