SQL Server According to Bob

MAY 19, 2019

The reduction effort started when we shipped SQL Server 2017 ( [link].) Partitioning allows SQL Server to scale to the largest systems with record-setting performance. When promoted to a super-latch on a 64 CPU system the memory requirement becomes 32 + (32 *64) = 2080 bytes. IO Request Caches. SQL Server 2017.

IoT 61

IoT Servers Development Cache 61

Smashing Magazine

JANUARY 21, 2021

After the latest redesign in late 2017, it was Ilya Pukhalski on the JavaScript side of things (part-time), Michael Riethmueller on the CSS side of things (a few hours a week), and yours truly, playing mind games with critical CSS and trying to juggle a few too many things. Moving From Automated Critical CSS Back To Manual Critical CSS.

Performance 145

Performance Cache Mobile Network 145

Brendan Gregg

SEPTEMBER 5, 2021

They claimed that the ZFS file system was consuming 30% of CPU capacity. I summarized this case study at Kernel Recipes in 2017; it is an old story that's worth resharing here. These included a breakdown of CPU time into percentages for "usr" (user: applications) and "sys" (system: the kernel).

Cache 52

Cache Cloud Java Tuning 52

Adrian Cockcroft

JANUARY 29, 2023

There is no way to model how much more traffic you can send to that system before it exceeds it’s SLA. This is unfortunate, because we’d really like to be able to build systems that have an SLA that we can share with the consumers of our interfaces, and be able to measure how well we are doing.

Lambda 98

Lambda Latency Cache C++ 98

Brendan Gregg

SEPTEMBER 5, 2021

They claimed that the ZFS file system was consuming 30% of CPU capacity. I summarized this case study at [Kernel Recipes] in 2017; it is an old story that's worth resharing here. ## 1. These included a breakdown of CPU time into percentages for "usr" (user: applications) and "sys" (system: the kernel). Ahh, it makes sense now.

Cache 40

Cache Cloud Java Tuning 40

Brendan Gregg

APRIL 14, 2022

offer letter logo (2014) flame graphs (2014) eBPF tools (2014-2019) PMC analysis (2017) my pandemic-abandoned desk (2020); office wall I joined Netflix in 2014, a company at the forefront of cloud computing with an attractive work culture. Netflix has been the best job of my career so far, and I'll miss my colleagues and the culture.

Java 52

Java Cache Cloud AWS 52

Alex Russell

JUNE 19, 2020

Perhaps there's a better solution, but I've been iterating on content and templates by firing up a linux terminal on my 2017 Pixelbook and starting the built-in 11ty filewatcher and browser sync tools. Eleventy is I/O heavy, and for correctness sake, it didn't do much caching. Copied 1189 files / Wrote 1175 files in 5.75 MiB | 2.99

Cache 49

Cache Hardware Speed Cloud 49

Sutter's Mill

FEBRUARY 13, 2017

Additionally, low latency increasingly matters at all scales: In user interfaces, low latency means responsive apps and productive users without the dreaded “wait…” donut; in financial trading, low latency regularly saves large amounts of cash; in embedded real-time systems, low latency is crucial to meeting deadlines and can even save lives.

Latency 51

Latency C++ Hardware Performance 51

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). What is MariaDB? What is MySQL?

Open Source 52

Open Source Servers Storage Scalability 52

MachMetrics

DECEMBER 14, 2019

In 2017, mobile internet usage passed desktop as the majority. It is typically reduced via server-side optimizations, such as enabling caching and database indexes. What is the number of resources I should stay under? How fast is the average time to first byte (server delay)? What impact does the increased use of mobile devices have?

Best Practices 105

Best Practices Speed Mobile Google 105

SQL Performance

SEPTEMBER 17, 2019

For years SSRS was bundled with the installation of SQL Server, which helped add to some of the confusion around licensing and support for the product, so beginning with SSRS 2017, the installation package for Reporting Services is a separate download. Unlike the system database tempdb, ReportServerTempDB is not recreated at startup.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Server According to Bob

DECEMBER 18, 2018

This means data can be stored in file system cache, non-stable media. ) The issue, as described in the link, is that the sync returns the error but may clear the state of the cached pages. Assume the database application opens the backup file, allowing file system caching (~_O_DIRECT.) reporting an EIO error.

Servers 40

Servers Media Cache Software Engineering 40

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. The L3 cache size is 64MB. The L3 cache size is 64MB. Since then, Microsoft has changed the naming of this series to Lsv2. lanes for I/O connectivity. Azure Lsv2 Details.

Azure 42

Azure Virtualization Storage Benchmarking 42

Smashing Magazine

JANUARY 7, 2019

You could go as far as evaluating a framework (or any JavaScript library) on Sacha Greif’s 12-point scale scoring system by exploring features, accessibility, stability, performance, package ecosystem, community, learning curve, documentation, tooling, track record, team, compatibility, security for example. Other options are available , too.

Performance 103

Performance Cache Metrics Network 103

Alex Russell

APRIL 29, 2021

After 20 years of neck-in-neck competition, often starting from common code lineages, there just isn't that much left to wring out of the system. Consistent improvement is the name of the game, and it can still have positive impacts, particularly as users lean on the system more heavily over time. Media Session API. Content Indexing.

Media 145

Media Games Education Engineering 145

Enprowess

JANUARY 12, 2022

So it is convenient for all to use irrespective of internet speed and it works offline using cached data. Twitter Lite PWA : It was integrated as the standard User Interface in 2017. IoT tracking systems. Blockchain technology is an encrypted database storage system. Pinterest PWA: Pins increased by 401%. Smart cities.

Blockchain 59

Blockchain IoT Development Serverless 59

Alex Russell

OCTOBER 22, 2017

— Alex Russell (@slightlylate) October 4, 2017. Tools and CI systems help them monitor progress & prevent regressions. Some systems show median RTTs near ~100ms for 3G users. Given the conflicted data we see across our other systems, this seems about right as a baseline. Maybe "ambush by JS"? First Load.

Performance 68

Performance Benchmarking Network Mobile 68

SQL Performance

JULY 16, 2019

They will also have up to 256MB of L3 cache per processor. These include your overall server CPU capacity, your single-threaded CPU performance, your memory density and capacity, your total I/O capacity, and your SQL Server 2017/2019 license costs. There are many reasons!

Servers 46

Servers Hardware Architecture Retail 46

The Netflix TechBlog

JULY 1, 2019

Our UI runs on top of a custom rendering engine which uses what we call a “surface cache” to optimize our use of graphics memory. Surface Cache Surface cache is a reserved pool in main memory (or separate graphics memory on a minority of systems) that the Netflix app uses for storing textures (decoded images and cached resources).

Cache 166

Cache Design Testing Development 166

Smashing Magazine

JANUARY 21, 2019

Note : Brad Frost’s “ Atomic Design ” is a great methodology for identifying these common patterns and building a reusable design system. Brad Frost identifies five distinct levels in atomic design for creating design systems. Native Client-Side Cache/Data Store. Large preview ).

Social Media 64

Social Media Database Media Website 64

SQL Server According to Bob

DECEMBER 31, 2018

iBytesRead = s.Read(bData, 0, c_iMaxReadSize); } }. . // Do we need to start the read-ahead to suck data into file system cache if (iCookie > -1) { tReadAhead.Start(iCookie); } }. CREATE EVENT SESSION [EventSequence] ON SERVER ADD EVENT sqlserver. sql_batch_completed ( ACTION ( package0. event_sequence , sqlserver.

Efficiency 40

Efficiency Code Servers Cache 40

All Things Distributed

OCTOBER 2, 2017

With these requirements in mind, and a willingness to question the status quo, a small group of distributed systems experts came together and designed a horizontally scalable distributed database that would scale out for both reads and writes to meet the long-term needs of our business. This was the genesis of the Amazon Dynamo database.

Internet 130

Internet Internet AWS Performance 130