The Morning Paper

NOVEMBER 5, 2019

File systems unfit as distributed storage backends: lessons from 10 years of Ceph evolution Aghayev et al., In this case, the assumption that a distributed storage backend should clearly be layered on top of a local file system. A distributed file system provides a unified view over aggregated storage from multiple physical machines.

Storage 64

Storage Systems Hardware Efficiency 64

DZone

AUGUST 21, 2019

CMake is a cross-platform system for automating project builds. This system is much older than the PVS-Studio static code analyzer, but no one has tried to apply the analyzer on its code and review the errors. CMake is a cross-platform system for automating software building from source code. The CMake audience is huge.

Programming 100

Programming Code Systems Software 100

PDC

APRIL 14, 2019

It ranks the world’s 500 most powerful supercomputers based on their performance as measured by the Linpack benchmark. In addition to performance, the Top500 list also summarises the main characteristics of the supercomputers in the list. This is also commonly known as “double precision” on many computer systems. Supercomputer.

Energy 40

Energy Benchmarking Efficiency Website 40

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

SQL Performance

MARCH 15, 2021

In my last post , I illustrated one reason you should stop using deprecated system tables like sysprocesses. This wasn't for performance reasons, directly, or to simply follow Microsoft's documented best practices, but revolved more around the decisions you might make when you only have access to some of the data.

Servers 64

Servers Azure Best Practices Monitoring 64

SQL Performance

SEPTEMBER 17, 2019

SSRS 2008 brought that component into the reporting service module. Unlike the system database tempdb, ReportServerTempDB is not recreated at startup. Caches of report results are stored in the ReportServerTempDB database and I/O performance can become an issue here. A scale-out deployment requires an Enterprise Edition license.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. The optimizer chooses this plan without any hints on my system configuration because the estimated cost of the plan is below the cost threshold for parallelism. Performance is competitive at around 15ms. BountyAmount ; Performance Summary Table.

Servers 86

Servers Tuning Database Efficiency 86

All Things Distributed

DECEMBER 18, 2012

Werner Vogels weblog on building scalable and robust distributed systems. I am pretty sure some if not all of these papers deserved to be elected to the hall of fame of best papers in distributed systems. Feb 11 - A Survey of Rollback-Recovery Protocols in Message-Passing Systems , E. All Things Distributed. Comments ().

Operating System 144

Operating System Cache AWS Scalability 144

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

SQL Server According to Bob

JUNE 22, 2016

Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Recommendation Unchanged: Prior to SQL Server 2016 enable –T8048 on larger systems. The three types of CMemThread partitioning and associated details are described in my previous post: [link].

Servers 40

Servers Azure Software Engineering Design 40

SQL Performance

OCTOBER 29, 2019

There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). Extended Events provides data about the individual execution of queries, while Query Store and the DMVs aggregate performance data. Each option has pros and cons. Example Scenario.

C++ 74

C++ Database Servers Tuning 74

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

Sutter's Mill

SEPTEMBER 24, 2010

6 Use Lock Hierarchies to Avoid Deadlock (Jan 2008). Feb 2008). 8 Going Superlinear (Mar 2008). 9 Super Linearity and the Bigger Machine (Apr 2008). 10 Interrupt Politely (May 2008). 11 Maximize Locality, Minimize Contention (Jun 2008). 12 Choose Concurrency-Friendly Data Structures (Jul 2008).

Programming 41

Programming Website Scalability Design 41

Sutter's Mill

AUGUST 27, 2010

6 Use Lock Hierarchies to Avoid Deadlock (Jan 2008). Feb 2008). 8 Going Superlinear (Mar 2008). 9 Super Linearity and the Bigger Machine (Apr 2008). 10 Interrupt Politely (May 2008). 11 Maximize Locality, Minimize Contention (Jun 2008). 12 Choose Concurrency-Friendly Data Structures (Jul 2008).

Website 40

Website Scalability Code Design 40

Sutter's Mill

JULY 12, 2010

6 Use Lock Hierarchies to Avoid Deadlock (Jan 2008). Feb 2008). 8 Going Superlinear (Mar 2008). 9 Super Linearity and the Bigger Machine (Apr 2008). 10 Interrupt Politely (May 2008). 11 Maximize Locality, Minimize Contention (Jun 2008). 12 Choose Concurrency-Friendly Data Structures (Jul 2008).

C++ 40

C++ Java Programming Website 40

All Things Distributed

MAY 8, 2012

Werner Vogels weblog on building scalable and robust distributed systems. Amazon RDS manages all these time consuming database administration tasks including patch management, striping the storage for better performance, and database and log backups for disaster recovery, enabling developers to focus more on their applications.

Cloud 116

Cloud Development AWS Servers 116

Dynatrace

JULY 24, 2023

The evolution of DevOps automation Since the concept of DevOps emerged around 2007 and 2008 in response to pain points with Agile development, DevOps automation has been continuously evolving. For instance, in the case of poor performance, you can seamlessly toggle a feature flag and mitigate any detrimental effects.

DevOps 222

DevOps Traffic Efficiency Servers 222

O'Reilly Software

OCTOBER 23, 2018

Technology systems are difficult to wrangle. Our systems grow in accidental complexity and complication over time. The product management team states what must be done to solve the problem, and the architect describes how to realize that vision in a system. To do so, we borrow metaphors from roles in other industries.

Strategy 100

Strategy Architecture Technology Technology 100

All Things Distributed

APRIL 5, 2012

Werner Vogels weblog on building scalable and robust distributed systems. 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. All Things Distributed. By Werner Vogels on 06 April 2012 06:00 AM. Comments ().

Innovation 149

Innovation AWS Education Network 149

The Agile Manager

SEPTEMBER 30, 2013

Technocracy was, too: "best practice" was derived from people performing narrowly defined tasks in rigid processes that yielded poor quality products at a high cost. Frederick Taylor defined and measured performance down to the task level. In the 1980s, it seemed we were on the cusp of a revolution in management.

Education 45

Education Best Practices Retail Network 45

Randon ASCII

FEBRUARY 11, 2018

I immediately saw that CcmExec.exe (part of Microsoft’s System Management Server ) had 508,000 handles open, which is both a lot and also amazingly close to my zombie count. I work on the Windows version of Chrome, and one of my tasks is optimizing its build system, which requires doing a lot of test builds.

Processing 72

Processing Programming Code Cache 72

The Agile Manager

FEBRUARY 28, 2017

Management textbooks dating at least as far back as the 1980s included stories of employees performing tasks the reasons for which they didn't really understand. There are people behind the systems to which we're bound today. Ten years ago, I was leading an inception for a company replacing their fleet maintenance systems.

Strategy 40

Strategy Java Code Systems 40

SQL Performance

APRIL 26, 2019

The DTU calculator is a free tool you can use to upload performance metrics from your server, and use the data to determine the appropriate service tier if you were to migrate that server to an Azure SQL Database (or to a SQL Database elastic pool ). NOTE : This process is not officially supported by SentryOne. Logical Disk – Disk Reads/sec.

Azure 40

Azure Database Metrics Servers 40

The Agile Manager

JUNE 11, 2010

Few understand that there is generally no such thing as a reachable long run except as a mathematical construct to solve equations - to assume a long run in a complex system you need to assume that nothing new will emerge. System integration will be logical, straightforward and seamless. A key supplier goes out of business.

Strategy 40

Strategy Systems Technology Technology 40

SQL Server According to Bob

JANUARY 26, 2017

Transparent Data Encryption (TDE) is a feature that was introduced in SQL Server 2008 (and is also available for Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse) with the purpose of encrypting your data at rest. This might have a performance effect for unencrypted databases on the same instance of SQL Server.

Servers 40

Servers Database Azure Cache 40

Smashing Magazine

AUGUST 20, 2021

During the 90s, we saw two content management systems for static sites — Microsoft FrontPage in 1996 and Macromedia Dreamweaver in 1997. These desktop applications incremented the tooling an inch closer to the modern Jamstack content management systems of today. Maintaining layouts became a particular pain point for static sites.

Ecommerce 139

Ecommerce Website Government Internet 139

John McCalpin

APRIL 2, 2020

This was a keynote presentation at the “2nd International Workshop on Performance Modeling: Methods and Applications” (PMMA16), June 23, 2016, Frankfurt, Germany (in conjunction with ISC16 ). This includes all architectures, all compilers, all operating systems, and all system configurations.

Benchmarking 59

Benchmarking Performance Latency Architecture 59

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. ​​ ​​ Start by ​​ determining ​​ what is registered on your system.

Network 40

Network Servers Processing Software Engineering 40

O'Reilly

SEPTEMBER 19, 2023

” Consider the structural evolutions of that theme: Stage 1: Hadoop and Big Data By 2008, many companies found themselves at the intersection of “a steep increase in online activity” and “a sharp decline in costs for storage and computing.” This technique simulates interactions in a complex system.

Hardware 99

Hardware Storage Big Data Blockchain 99

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

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. The DataTable can be created multiple ways in the.NET code, but a common way to create the table is something like the following: System.

Servers 55

Servers Azure Hardware Network 55

SQL Performance

JUNE 21, 2019

I always check backups first when looking at a new system. What I find is very similar to backups: No DBCC CHECKDBs performed at all DBCC CHECKDBs being performed only on select databases DBCC CHECKDBs last performed months or years ago. Memory settings. Statistics. Index maintenance. SQL Server Agent alerts.

Servers 49

Servers Azure Hardware Database 49

SQL Performance

AUGUST 27, 2019

This system has one AMD EPYC 7502P 32-core processor and 512GB of RAM. The price per QphH for this system is 0.34 That is a higher score, but this system used two Intel Xeon Platinum 8180 28-core processors (that had a total of 56C/112T) and 512GB of RAM. The price per QphH for this system is 0.47 In this case, 6,716.88/64

Servers 52

Servers Benchmarking Virtualization Architecture 52

Alex Russell

AUGUST 30, 2021

Does Apple restrict, in any way, the ability of competing web browsers to deploy their own web browsing engines when running on Apple's operating system? From 2008 to 2013, the Chrome project was based on WebKit, and a growing team of Chrome engineers began to contribute heavily "upstream." If no, please explain why not.

Engineering 98

Engineering Open Source Website Operating System 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. System locks also count, but these are rarely held for long and aren’t associated with the user transaction. Let’s look at some examples using a fresh database.

Database 98

Database Storage Testing Servers 98

The Agile Manager

APRIL 30, 2013

Revenues plummeted at the end of 2008. Managers coped with smaller staffs by asking employees to perform multiple jobs and to work longer hours. This prevented companies from losing employees with systemic knowledge of the business and intimate knowledge of customers. Companies retrenched by laying people off. And cut they did.

Small Business 40

Small Business Efficiency Innovation Systems 40

Highly Scalable

MARCH 10, 2015

Most of this article represents an overview of the results published by retailers and researchers who built practical decision making and optimization systems combining abstract economic models with data mining methods. Moreover, gross margin is not the only performance metric that is important for retailers. Applications.

Retail 152

Retail C++ Analytics Metrics 152