O'Reilly

NOVEMBER 28, 2023

If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” A year after the first web servers became available, how many companies had websites or were experimenting with building them? Until AI reaches 100%, it’s still in the process of adoption.

Open Source 106

Open Source Artificial Intelligence Google Infrastructure 106

SQL Performance

JANUARY 23, 2020

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.

Tuning 115

Tuning Servers Monitoring Hardware 115

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. 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. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS. Statistics.

Servers 49

Servers Azure Hardware Database 49

Percona

APRIL 17, 2023

The main objective of this post is to share my experience over the past years tuning MongoDB and centralize the diverse sources that I crossed in this journey in a unique place. systemctl stop tuned $ systemctl disable tuned Dirty ratio The dirty_ratio is the percentage of total system memory that can hold dirty pages.

Best Practices 52

Best Practices Design Tuning Database 52

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

Percona

AUGUST 27, 2018

MySQL 8 introduced a feature that is explained only in a single documentation page. It is well hidden in the Optimization: Optimizing the MySQL Server chapter. Then we need to see IF implementing the tuning will work or not. It is possible to do more tuning in the case that ETL is too compromised. Will this work?

Tuning 44

Tuning Virtualization Testing Servers 44

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40

Adrian Cockcroft

NOVEMBER 13, 2023

The carbon footprint of a large rack mounted server is order-of-magnitude a ton of carbon a year. I’ve written before about how to tune out retry storms. Both are well documented and standardized, but most of the discussion occurs around attributional accounting.

Energy 52

Energy Cloud Traffic Transportation 52

Brendan Gregg

SEPTEMBER 5, 2017

Linux has been adding tracing technologies over the years: kprobes (kernel dynamic tracing), uprobes (user-level dynamic tracing), tracepoints (static tracing), and perf_events (profiling and hardware counters). There's a lot about Linux containers that isn't well documented yet, especially since it's a moving target.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Percona

AUGUST 5, 2023

KEY partitioning KEY partitioning is similar to HASH partitioning, except that only one or more columns to be evaluated are specified, and the MySQL server provides its own hashing function. This helps identify potential issues and fine-tune the partitioning strategy. Documentation : Always be documenting!

Strategy 40

Strategy Storage Database Best Practices 40

Dotcom-Montior

OCTOBER 12, 2017

EasyTravel demo application on AWS server. LoadView scripting tool Easystep on AWS server. Firewall on AWS server. AWS server security policy. Add inbound and outbound windows firewall rule on test server for port 8079. Link to my Easytravel demo application hosted on AWS server: [link]. Installation.

AWS 40

AWS Tuning Monitoring Servers 40

HammerDB

FEBRUARY 25, 2021

When we have multiple CPU cores on both the benchmark client and database server it is crucial that these database sessions run independently of each other at the same time, in parallel. The following is an example from TPROC-C from SQL Server. and the following from TPROC-H. select top 100. where p_partkey = ps_partkey. Glue language.

Programming 67

Programming Benchmarking Virtualization C++ 67

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. TheYear , CA.

Servers 95

Servers Tuning Architecture Processing 95

Smashing Magazine

AUGUST 22, 2021

Latency can be roughly defined as the time it takes to send a packet from point A (say, the client) to point B (the server). This is one of the main reasons why content delivery networks (CDNs) exist: They place servers physically closer to the end user in order to reduce latency, and thus delay, as much as possible. and prior (a)).

Performance 106

Performance Network Latency Servers 106

O'Reilly

OCTOBER 11, 2022

We’ll see it in the processing of the thousands of documents businesses handle every day. It’s possible to augment this basic process with OCR so the application can find data on paper forms, or to use natural language processing to gather information through a chat server. We’ll see it in customer service. We’ll see it in compliance.

Games 114

Games Healthcare Processing Retail 114

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. I will compare AWS Aurora with MySQL (Percona Server) 5.6 84.1 | | version_comment | Percona Server (GPL), Release 84.1, Documentation: [link].

Cache 46

Cache C++ AWS Airlines 46

High Scalability

NOVEMBER 25, 2019

Document store. Application Servers. Apache FTP server. Native desktop and server hosted clients that allow both interactive as well as hybrid sync access to the entire namespace. Tens of petabytes of data stored in our servers and other object stores such as GCS, S3 and Azure Blobstore. Video Transcoding.

Architecture 52

Architecture Cache Azure Storage 52