SQL Performance

APRIL 10, 2019

The ISO/IEC 9075:2016 standard, or SQL:2016 in short, introduces support for a profound concept called Row Pattern Recognition (RPR) in SQL. The SQL:2016 standard provides two main RPR-related features: Feature R010, “Row pattern recognition: FROM clause”. Feature R010, “Row pattern recognition: FROM clause”.

C++ 73

C++ Virtualization Servers Code 73

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. It's an exciting development in cloud computing: hardware virtualization is now fast. Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds.

Virtualization 40

Virtualization AWS Hardware Storage 40

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. Both of these Intel processors are special bespoke models that are not in the Intel ARK database. The key specifications for the Lsv2 series virtual machines are shown in Table 1.

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Performance

FEBRUARY 1, 2022

The transaction log contains virtual log files, which contain log blocks, which store the actual log records. Virtual Log Files. The transaction log is split up into sections called virtual log files , commonly just called VLFs. You’d think the sequence numbers would start at 1 for a brand-new database, but that is not the case.

Architecture 53

Architecture Servers Virtualization Database 53

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. Microsoft SQL Server Database Engine Input/Output Requirements. product: Virtual Disk. Msft Virtual Disk 1.0 The Back Story. Fua (Forced Unit Access). lshw -class disk.

Servers 90

Servers Media Cache Storage 90

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

O'Reilly

APRIL 5, 2023

Worse yet, the AI’s bias would likely find its way into the system’s database and follow the students from one class to the next. In 2016, Microsoft’s Tay chatbot was shut down after making racist and sexist comments. In 2016, Microsoft’s Tay chatbot was shut down after making racist and sexist comments.

Artificial Intelligence 109

Artificial Intelligence Energy Government Virtualization 109

Alex Russell

APRIL 29, 2021

At the time of the last Confluence run, the gap had stretched to nearly 1000 APIs, doubling since 2016. Now in development in WebKit after years of radio silence, WebXR APIs provide Augmented Reality and Virtual Reality input and scene information to web applications. But perhaps counting APIs gives a distorted view?

Media 145

Media Games Education Engineering 145

The Symphonia

DECEMBER 6, 2017

Correspondingly, 3GB functions should see a 2x CPU performance improvement over 1.5GB Lambdas, but this is through doubling the number of cores the function has access to, rather than double the virtualized time-slices. Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. But this year?

Serverless 40

Serverless Lambda AWS Traffic 40

Alex Russell

MAY 9, 2022

This often happens out of an ad-hoc virtual team that forms in earlier stages but is now formalised and has long-term staffing. miAi3020A9G #perfmatters 1 10:04 AM · Jul 7, 2016. When database speed or server capacity is the biggest variable, issues affect managers and executives at the same rate they impact end users.

Performance 86

Performance Latency Metrics Engineering 86