SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. Despite all of this, Intel is not going to lose their entire server processor business any time soon. So, what has changed my mind?

Servers 46

Servers Hardware Architecture Retail 46

SQL Performance

MAY 16, 2019

Without this guarantee, SQL Server might add index rows that are not sorted correctly, which would not be good. For INSERT.SELECT , SQL Server makes its own determination whether to ensure rows are presented to the Clustered Index Insert operator in key order or not. DMLRequestSort Conditions.

Cache 67

Cache Servers Testing Storage 67

SQL Performance

APRIL 8, 2019

These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. This 14nm first-generation AMD EPYC 7551 processor has 32 cores and 64 threads, and it works in one or two-socket servers. The L3 cache size is 64MB. The L3 cache size is 64MB. AMD EPYC 7551 Details.

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. – [link]. Auto-soft NUMA. . ….

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. Ryan Stonecipher – Principle SQL Server Software Engineer. SQL Server. set nocount on.

Hardware 40

Hardware Cache Servers Software Engineering 40

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process.

Open Source 52

Open Source Servers Storage Scalability 52

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 Moto G4 , for example. The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively.

Performance 124

Performance Network Cache Metrics 124

ACM Sigarch

MARCH 25, 2019

Figure 1 depicts a simple queue where tasks arrive, are optionally queued in the buffers to the left if the server is already busy, are then serviced one at a time in the circular server, and depart to the right. For the previous cache miss buffer example, the 32-buffer answer is minimal for 100-ns average miss latency.

Systems 53

Systems Latency Performance C++ 53

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. From SQL Server 2016 onward, FastLoadContext is enabled by default ; the trace flag is not required. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016.

Cache 64

Cache Testing Servers Code 64

Brendan Gregg

JULY 2, 2021

cachestat File system cache statistics line charts 7. The architecture is: While the bpftrace binary is installed on all the target systems, the bpftrace tools (text files) live on a web server and are pushed out when needed. execsnoop New processes (via exec(2)) table 2. opensnoop Files opened table 3. It depends on the tool.

Open Source 40

Open Source Latency Cache Energy 40

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). SQL Server makes some timing adjustments in parallel plans to promote consistency, but they are not perfectly implemented.

Servers 95

Servers Tuning Architecture Processing 95

SQL Server According to Bob

DECEMBER 31, 2018

How It Works: XEvent Output and Visualization SQL Server Management Studio Provides–“XE Profiler” Use the SSMS XEvent Profiler. 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. TSQL Sample Session.

Efficiency 40

Efficiency Code Servers Cache 40

Abhishek Tiwari

NOVEMBER 3, 2018

If you put your whole website on CDN, technically you don’t need a large number of server infrastructure and CMS licenses. They often get blindsided by vendor’s pitch and end-up making decision based on some fancy demos (see my post from 2014 on Adobe AEM ). Circa 2014, I was working with a big Japanese automotive brand in Australia.

Systems 63

Systems Cache Website Network 63