Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory.

Performance 110

Performance Latency Cache Virtualization 110

SQL Performance

MARCH 29, 2022

Simple parameterization has a number of quirks in this area, which can result in more parameterized plans being cached than expected, or finding different results compared with the unparameterized version. When SQL Server applies simple parameterization to an ad-hoc statement, it makes a guess about the data type of the replacement parameter.

Cache 90

Cache Servers Database Testing 90

SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. Despite all of this, Intel is not going to lose their entire server processor business any time soon. So, what has changed my mind?

Servers 46

Servers Hardware Architecture Retail 46

Smashing Magazine

OCTOBER 29, 2019

2019-10-29T12:30:59+02:00. 2019-10-29T13:36:09+00:00. As of writing this in 2019, Can I use… has accounted for the following platforms that support WebP: ‘Can I Use’ breaks down which browsers and versions of those browsers provide support for WebP. Still, it takes a bit of work to modify the origin servers to make this happen.

Website 72

Website Speed Cache Google 72

SQL Performance

MARCH 22, 2022

In this first part, after a quick introduction, I look at the effects of simple parameterization on the plan cache. It's almost always better to explicitly parameterize statements, rather than relying on the server to do it. The aim is to reduce compilations by increasing cached plan reuse. Simple Parameterization. Shell Plans.

Cache 61

Cache Servers Database Code 61

SQL Performance

JUNE 8, 2022

When the parser allows simple parameterization to continue, SQL Server® increments the Auto-Param Attempts/sec counter of the SQL Statistics object. Let’s now continue following the compilation process noting the effects on simple parameterization as we go. Let’s look at the plan cache: SELECT. Let’s look at an example.

Cache 54

Cache Servers Database Processing 54

HammerDB

JUNE 27, 2022

The Transaction Processing Performance Council (TPC) was founded to bring standards to database benchmarking, and the history of the TPC can be found here. Given the increasing importance of open source and the widespread use of HammerDB, the TPC adopted HammerDB in 2019 and now hosts the project on GitHub. Cached vs Scaled Workloads.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Smashing Magazine

JUNE 20, 2019

2019-06-20T11:00:16+02:00. 2019-06-20T10:35:07+00:00. Browser Caching. Another built-in optimization of Google Fonts is browser caching. As the Google Fonts API becomes more widely used, it is likely visitors to your site or page will already have any Google fonts used in your design in their browser cache.

Google 111

Google Performance Cache Website 111

Smashing Magazine

JANUARY 11, 2021

Build Optimizations JavaScript modules, module/nomodule pattern, tree-shaking, code-splitting, scope-hoisting, Webpack, differential serving, web worker, WebAssembly, JavaScript bundles, React, SPA, partial hydration, import on interaction, 3rd-parties, cache. Establish a performance culture. Large preview ). What does it mean?

Performance 145

Performance Cache Media Metrics 145

SQL Performance

MAY 20, 2022

The Compilation Process. The most important things to understand about server-side parameterization are it doesn’t happen all at once and a final decision to parameterize isn’t made until the end of the process. These rules might seem odd or arbitrary but they were created for SQL Server 7.0 usecounts , CP.

Cache 55

Cache Database Servers Testing 55

SQL Performance

APRIL 18, 2022

It’s no surprise even highly experienced SQL Server users tend to get this wrong, given the contradictory information often supplied to us. Let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14, with database compatibility set to 150. It’s important to remember the plan must be cached.

Cache 58

Cache Servers Database Testing 58

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory.

Performance 52

Performance Latency Cache Virtualization 52

Smashing Magazine

JULY 29, 2019

2019-07-29T14:00:59+02:00. 2019-07-29T13:06:57+00:00. The United Kingdom is ranked 34th out of 207 countries for broadband speed, but in July 2019 there was still a school in the UK without broadband. Again, the cost is negligible, but wastes some compression CPU time on the server and decompression CPU time on the client.

Cache 96

Cache Google Mobile Network 96

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

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? Also, as Patrick Meenan suggested, it’s worth to plan out a loading sequence and trade-offs during the design process.

Performance 145

Performance Cache Network Metrics 145

KeyCDN

MAY 14, 2019

We’re thrilled to announce that we’ve added the Image Processing feature! It’s no longer necessary to store several variations of the same image on your server. How Does Image Processing Work? The Image Processing feature is available on all Pull Zones. For example, the query string ?

Processing 13

Processing Cache Latency Network 13

SQL Performance

AUGUST 4, 2022

To recap: Normalization and decoding promote cached plan reuse. Let’s now continue following the compilation process to see how SQL Server decides if simple parameterization is safe or unsafe. The CBO has significant start-up and runtime costs and may consume significant server resources. Generating a Trivial Plan.

Servers 61

Servers Cache Database Availability 61

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. Advances in browser content processing. The worldwide ASP 18 months ago was ~$300USD , so the average performance in the deployed fleet can be represented by a $300 device from mid-2019.

Performance 124

Performance Network Cache Metrics 124

Smashing Magazine

APRIL 17, 2019

2019-04-17T12:30:16+02:00. 2019-04-29T18:34:58+00:00. A DNS lookup is the process of turning a human-friendly domain name like example.com into the machine-friendly IP address like 123.54.92.4 The browser caches the results of these lookups, but they can be slow. Optimizing Performance With Resource Hints. Drew McLellan.

Performance 106

Performance Games Servers Cache 106

The Morning Paper

OCTOBER 4, 2020

The study is based on one of the world’s first commercial 5G network deployments (launched in April 2019), a 0.5 In the radio portion of the network, 5G buffer sizes are 5x 4G, but within the wired portion of the network only about 2.5x (this is with a 1000 Mbps provisioned cloud server). km university campus.

Energy 130

Energy Latency Performance Network 130

Enprowess

SEPTEMBER 7, 2021

Software Developers got to use JavaScript CLI tools to create the back-end part of web applications or server-side. allows creating web application’s server-side or back-end components. is a server-side, open-source, JavaScript runtime environment that allows developers to write JavaScript on the client and the server-side.

Open Source 52

Open Source Virtualization Programming Servers 52

SQL Performance

NOVEMBER 30, 2021

SQL Server has a cost-based optimizer that uses knowledge about the various tables involved in a query to produce what it decides is the most optimal plan in the time available to it during compilation. However, nothing easily allows SQL Server to determine what percentage of the leaf level for each index of a table is already in memory.

Efficiency 54

Efficiency Servers Database Cache 54

Rigor

SEPTEMBER 3, 2019

What you may be overlooking is that peak-event readiness is about more than just load testing or ensuring that your servers are up throughout a specific timeframe. They seem to have learned from their mistakes for Prime Day 2019.). Servers down or server health issues [APM].

Website 74

Website Cache Traffic Ecommerce 74

Smashing Magazine

JANUARY 15, 2019

2019-01-15T13:30:32+01:00. 2019-04-29T18:34:58+00:00. So, apart from powering servers with renewable energy, what else can web developers do about climate change? This includes the work done by the server, the client and the intermediary communications networks that transmit data between the two. Server-Side Performance.

Website Performance 73

Website Performance Website Energy Performance 73

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. SET NOCOUNT , XACT_ABORT ON ; -- Prevent plan caching for this procedure. -- See [link]. Testing environment. GOTO Start. OPEN SYMMETRIC KEY Banana.

Database 98

Database Storage Testing Servers 98

Smashing Magazine

OCTOBER 26, 2018

2019-04-29T18:34:58+00:00. In addition to MVC separation, we can (for security reasons or speed improvements) place the JS App on a separate server like in the schema below: Decoupled WordPress diagram. Recommended reading : WordPress Security As A Process. Headless WordPress: The Ups And Downs Of Creating A Decoupled WordPress.

Cache 78

Cache Website Speed Database 78

Smashing Magazine

OCTOBER 22, 2019

2019-10-22T12:30:59+02:00. 2019-10-22T13:06:35+00:00. According to HTTP Archive : The median size of a desktop website in 2019 is 1939.5 The median size of a mobile website in 2019 is 1745.0 You’re going to have to go through this same process whether images come from a stock site or from someone’s DSLR.

Mobile 63

Mobile Media Website Storage 63

SQL Performance

NOVEMBER 4, 2021

First introduced in SQL Server 2017 Enterprise Edition, an adaptive join enables a runtime transition from a batch mode hash join to a row mode correlated nested loops indexed join (apply) at runtime. This is a just a presentation decision—the Concat and joins are still present in the code run by the SQL Server execution engine.

Servers 98

Servers Design Database Code 98

Smashing Magazine

APRIL 9, 2019

2019-04-09T12:30:59+02:00. 2019-04-29T18:34:58+00:00. Most sites were all hosted on a single physical server somewhere on our own hosting infrastructure, and it was the server we thought about defending when it came to security best practices. file hosted as part of their own website on their own server.

Website 58

Website Servers Code Best Practices 58

Smashing Magazine

JUNE 26, 2019

2019-06-26T14:00:59+02:00. 2019-06-26T14:06:48+00:00. Let the web developer handle all of the necessary speed optimizations like caching and file minification while you take on the following design tips and strategies: 1. After all, Opens Sans is a Google Font that has to be served from Google’s servers. Suzanne Scacca.

Website 110

Website Speed Mobile Design 110

KeyCDN

JULY 11, 2019

Well, according to HTTP Archive , as of June 1, 2019 the average desktop page is 1,896.8 Ways to Optimize Your Images There are many ways that you can optimize your images, such as utilizing image processing services and image compression software, choosing better image formats, using srcset and sizes attributes.

Speed 52

Speed Website Mobile Latency 52

KeyCDN

SEPTEMBER 12, 2019

Well, according to HTTP Archive , as of June 1, 2019 the average desktop page is 1,896.8 An easy way to compress images is with our image processing service that happens to also be fully integrated into our existing network. This is useful if you want to store optimized images instead of using a real-time image processing service.

Social Media 106

Social Media Media Google Website 106

Enprowess

JANUARY 12, 2022

So it is convenient for all to use irrespective of internet speed and it works offline using cached data. Convenient Debugging : Debugging process is easy for the developers as single page application SPA offer developers tools. Approximately more than 34 million blockchain wallets were used globally in 2019. Image Source.

Blockchain 59

Blockchain IoT Development Serverless 59

The Morning Paper

APRIL 11, 2019

UPDATE 2019-04-14: An author update has been published for this paper which details that with current browser versions, ServiceWorkers can only stay alive for about a minute after the user navigates away from the site. Master of web puppets: abusing web browsers for persistent and stealthy computation Papadopoulus et al., NDSS’19.

Website 44

Website Network Traffic Cache 44

The Netflix TechBlog

DECEMBER 17, 2019

Nonetheless, we found a number of limitations that could not satisfy our requirements e.g. stalling the processing of log events until a dump is complete, missing ability to trigger dumps on demand, or implementations that block write traffic by using table locks. Some of DBLog’s features are: Processes captured log events in-order.

Database 212

Database Traffic Transportation Open Source 212

The Netflix TechBlog

DECEMBER 17, 2019

Nonetheless, we found a number of limitations that could not satisfy our requirements e.g. stalling the processing of log events until a dump is complete, missing ability to trigger dumps on demand, or implementations that block write traffic by using table locks. Some of DBLog’s features are: Processes captured log events in-order.

Database 197

Database Traffic Transportation Open Source 197