SQL Performance

MAY 16, 2019

Both of the following tests must pass for SQL Server to choose to set DMLRequestSort to true when inserting to an empty clustered index with table locking specified: An estimate of more than 250 rows at the input side of the Clustered Index Insert operator; and. Test ; END ; GO. spt_values AS SV ; Plan Caching. DROP TABLE dbo.

Cache 67

Cache Servers Testing Storage 67

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

SQL Server According to Bob

JUNE 3, 2016

In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. Try SQL Server 2016 Today.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Server According to Bob

JUNE 3, 2016

The following chart shows the same 1TB database testing. Use SQL Server Management Studio (SSMS) or your favorite query editor to connect to a SQL Server 2012 or 2014 instance. Note: You may need to execute the dbcc a second time so buffer cache is hot, eliminating I/O sub-system variants. SQL Server 2014.

Hardware 40

Hardware Cache Servers Software Engineering 40

Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. mid-priced Androids were slightly faster than 2014's iPhone 6. The professionalism with which the new Core Web Vitals (CWV) have been developed, tested, and iterated on inspires real confidence.

Performance 124

Performance Network Cache Metrics 124

Alex Russell

APRIL 29, 2021

Thanks to the Web Platform Tests project and wpt.fyi , we have the makings of an answer for the first: Tests that fail only in a given browser. wpt.fyi 's new Compat 2021 dashboard narrows this full range of tests to a subset chosen to represent the most painful compatibility bugs : Stable-channel Compat 2021 results over time.

Media 145

Media Games Education Engineering 145

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52