SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. Performance is competitive at around 15ms. This code is provided for interest and is not included in the performance summary table. BountyAmount ; Performance Summary Table. Performance Summary Table (duration / CPU in milliseconds).

Servers 86

Servers Tuning Database Efficiency 86

All Things Distributed

MAY 8, 2012

of administrative tasks such as OS and database software patching, storage management, and implementing reliable backup and disaster recovery solutions. Amazon RDS currently supports SQL Server 2008 R2 and plans to add support for SQL Server 2012 later this year.

Cloud 116

Cloud Development AWS Servers 116

SQL Performance

MAY 1, 2020

I was a bit perplexed by this issue, since the system was certainly no slouch — plenty of cores, 3TB of memory, and XtremIO storage. If you have instances running older versions like SQL Server 2008 R2 (I found one!), writes/sec average throughput: 46.96

C++ 58

C++ Database Servers Storage 58

All Things Distributed

DECEMBER 18, 2012

Aug 24 - The Five-Minute Rule Ten Years Later, and Other Computer Storage Rules of Thumb , Jim Gray and Goetz Graefe, ACM SIGMOD Record 26 (4): 63â??68, Goetz Graefe, ACM Queue 6(4): 40-52 (2008). Nov 17 - Scale and performance in a distributed file system , John H. Needham and Michael D. Howard, Michael L. Kazar, Sherri G.

Operating System 144

Operating System Cache AWS Scalability 144

SQL Performance

MAY 16, 2019

Achieving minimal logging using INSERT.SELECT into an empty clustered index target is not quite as simple as described in the Data Performance Loading Guide. The Data Loading Performance Guide contains a high-level summary of the conditions required for minimal logging into clustered tables: This post is concerned with the top row only.

Cache 67

Cache Servers Testing Storage 67

All Things Distributed

APRIL 5, 2012

Jack: Since our launch in late 2008, weve grown to over 6 million teachers and students globally primarily through word of mouth of teachers who have shared Edmodo with each other. Jack: We want to deliver an even more performance and rock solid experience for our global user base of teachers, students, administrators and parents.

Innovation 149

Innovation AWS Education Network 149

High Scalability

APRIL 3, 2019

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 177

Database Cloud Open Source Systems 177

O'Reilly

SEPTEMBER 19, 2023

It progressed from “raw compute and storage” to “reimplementing key services in push-button fashion” to “becoming the backbone of AI work”—all under the umbrella of “renting time and storage on someone else’s computers.” ” (It will be easier to fit in the overhead storage.)

Hardware 99

Hardware Storage Big Data Blockchain 99

SQL Server According to Bob

JANUARY 11, 2020

​​​​ The entire Tabular Data Stream protocol (TDS) is documented here: ​​ [link] ​​ A ​​ login request performs the following steps.

Network 40

Network Servers Processing Software Engineering 40

O'Reilly

JULY 25, 2023

And if I switch tabs to view a paper from 2008, then a song from 2008 could start up. To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022.

Programming 98

Programming Code Design Benchmarking 98

SQL Performance

SEPTEMBER 6, 2022

I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. A quirk of the implementation means no check is performed when the count of held locks is exactly 1250. Let’s look at some examples using a fresh database. Well, almost.

Database 98

Database Storage Testing Servers 98

SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. How does this impact performance you may wonder? InvariantCulture. }

Servers 55

Servers Azure Hardware Network 55

SQL Performance

AUGUST 27, 2019

If you divide that total score by the number of physical cores in the system, you will get a "score per core" which is a good measure of the single-threaded performance of the processor used in the system. Single-threaded CPU performance is the one relative weak point of the AMD EPYC 7742 processor. In this case, 6,716.88/64

Servers 52

Servers Benchmarking Virtualization Architecture 52

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016. We must also remember the final storage engine test for at least 100 rows: I >= 100. Fast Load Context.

Cache 64

Cache Testing Servers Code 64

Alex Russell

AUGUST 30, 2021

From 2008 to 2013, the Chrome project was based on WebKit, and a growing team of Chrome engineers began to contribute heavily "upstream." Safari on iOS has been endowed with JIT for many years, whereas competing browsers were prevented from approaching similar levels of performance. decoding="async" loading="lazy" />.

Engineering 98

Engineering Open Source Website Operating System 98

Brendan Gregg

SEPTEMBER 5, 2017

Nowadays, there are three built-in tracers that you should know about: - **ftrace**: since 2008, this serves many tracing needs, and has been enhanced recently with hist triggers for custom histograms. As a performance engineer who does kernel tracing, I find the lack of an ID I can trace in the kernel to be pretty annoying.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Percona

JANUARY 14, 2019

With the latest ClickHouse version, all of these features are available, but some of them may not perform fast enough. In a partitioned massively parallel database system, the storage format and sorting algorithm may not be optimized for that operation as we are reading multiple partitions in parallel. Deleting messages. Text search.

Database 40

Database Analytics Blockchain Healthcare 40