SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Microsoft SQL Server Database Engine Input/Output Requirements. Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system.

Servers 90

Servers Media Cache Storage 90

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. The Linux default is usually 60 , which is not ideal for database usage. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices 52

Best Practices Design Tuning Database 52

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

Smashing Magazine

JANUARY 6, 2020

On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). From Addy’s article “ Loading Web Pages Fast On A $20 Feature Phone ”. To achieve the goals stated in the first paragraph, we have to consider the critical file size budget for JavaScript.

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 7, 2019

On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). awesome-webpack is a curated list of useful Webpack resources, libraries and tools, including articles, videos, courses, books and examples for Angular, React and framework-agnostic projects.

Performance 103

Performance Cache Metrics Network 103

Highly Scalable

APRIL 2, 2012

In this article, I describe major architectural decisions we made and techniques we used. I can recommend this article by Peter Morville and Jeffrey Callender for further reading. So, the only way was to cache all necessary data to minimize interaction with RDBMS. There is a lot of information about faceted search on the web.

Ecommerce 100

Ecommerce Cache Storage Architecture 100

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? KB boundary   12 Larger transaction logs   13 Restore and attach   14 Format for 4 ?KB

Servers 40

Servers Cache Database Media 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. Hardware Past As Performance Prologue. Regardless, the overall story for hardware progress remains grim, particularly when we recall how long device replacement cycles are: Tap for a larger version.

Performance 124

Performance Network Cache Metrics 124

Highly Scalable

AUGUST 20, 2013

This article is an effort to explore techniques used by developers of in-stream data processing systems, trace the connections of these techniques to massive batch processing and OLTP/OLAP databases, and discuss how one unified query engine can support in-stream, batch, and OLAP processing at the same time.

Big Data 154

Big Data Processing Lambda Database 154

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. In this article, we will look at how this can improve the reporting/analytical query performance in MySQL. The second and third run used the cached data. With faster disks (i.e. MySQL on ec2.

Cache 47

Cache C++ AWS Airlines 47

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. how much data does the browser have to download to display your website) and resource usage of the hardware serving and receiving the website.

Website Performance 73

Website Performance Website Energy Performance 73

SQL Performance

MARCH 8, 2021

This article aims to help you understand where the timings come from in each case, and how they can be best interpreted in context. The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo. The clock keeps running at the same rate even during sleep.

Servers 95

Servers Tuning Architecture Processing 95

High Scalability

NOVEMBER 25, 2019

In this article, I will share the current architecture and some of the lessons we learned scaling it along with some of the things we are looking to improve upon in the near future. Edge caching. In general, Egnyte connect architecture shards and caches data at different levels based on: Amount of data. Disk based caching.

Architecture 52

Architecture Cache Azure Storage 52