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

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server. Description.

IoT 61

IoT Servers Development Cache 61

SQL Performance

MARCH 30, 2021

This five-part series takes a deep dive into the way SQL Server row mode parallel plans start up. ) ; My test environment is SQL Server 2019 CU9 on a laptop with 8 cores and 16GB of memory allocated to the instance. See Myth: SQL Server Caches a Serial Plan with every Parallel Plan for details.

Cache 98

Cache Servers Processing Operating System 98

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

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 97

Cache Mobile Google Network 97

Smashing Magazine

APRIL 17, 2019

2019-04-17T12:30:16+02:00. 2019-04-29T18:34:58+00:00. Every time you type a URL in the browser address bar, follow a link in a page or even load a resource like an image from a different domain, the browser needs to do a DNS lookup to find the server that holds the resource we’ve requested. Drew McLellan. Preconnecting.

Performance 107

Performance Servers Games Cache 107

The Netflix TechBlog

DECEMBER 17, 2019

This way, log event processing can resume event-by-event afterwards, eventually discovering the watermarks, without ever needing to cache log event entries. This is why our approach is briefly pausing log processing during steps 2–4 so that the watermarks are not missed. Beresford, and Boerge Svingen. Online event processing.

Database 223

Database Traffic Transportation Open Source 223

The Netflix TechBlog

DECEMBER 17, 2019

This way, log event processing can resume event-by-event afterwards, eventually discovering the watermarks, without ever needing to cache log event entries. This is why our approach is briefly pausing log processing during steps 2–4 so that the watermarks are not missed. Beresford, and Boerge Svingen. Online event processing.

Database 209

Database Traffic Transportation Open Source 209

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 103

Performance Latency Cache Virtualization 103

KeyCDN

MAY 14, 2019

It’s no longer necessary to store several variations of the same image on your server. This will reduce the total number of image operations because once the image has been processed it will be cached by our shield servers, allowing our edge servers to pull and cache the processed image instead of having to process the image again.

Processing 13

Processing Cache Network Latency 13

Smashing Magazine

MAY 25, 2021

A number of sites moved to font-display: swap when this first came out, and Google Fonts even made it the default in 2019. It’s also trickier to handle cached fonts we already have, not to mention differences in various fallback styles. However, beyond that it didn’t really solve the problem.

Operating System 144

Operating System Google Website Cache 144

MachMetrics

DECEMBER 27, 2019

It can also be described as server delay. TTFB is typically reduced via server-side optimizations, such as enabling caching and database indexes. The post Year in Web Performance: 2019 appeared first on MachMetrics Speed Blog. Time to first byte is a blocker for all other metrics that follow it.

Performance 52

Performance Speed Website Mobile 52

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. 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. So what did $150USD fetch in 2019?

Performance 127

Performance Network Metrics Cache 127

MachMetrics

JUNE 30, 2021

John Mueller answered “YES” to this question in 2019, “site speed is definitely a ranking factor?”. The factors that impact on LCP: Slow origin server response times Render-blocking JavaScript and CSS on page load Page Resource load times User side page rendering. Role of web servers in page load time –.

Cache 78

Cache Speed Google Website 78

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

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

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 Performance 95

MachMetrics

DECEMBER 20, 2018

It’s now almost 2019, and there are no more excuses. Now let’s upload our lazy-loading updates and try again: (Note that you’ll have to do hard-reload, clear cache, or use a new private browser to ensure we’re not taking advantage of the browser cache in our testing). Well isn’t that beautiful?!

Cache 75

Cache Speed Internet Internet 75

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

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 111

Website Speed Mobile Design 111

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 74

Website Performance Website Energy Performance 74

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

HammerDB

JUNE 27, 2022

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. A key difference between cached and scaled workloads is the implementation of keying and thinking time to introduce a pause of time between transactions.

Benchmarking 63

Benchmarking Open Source C++ Cache 63

KeyCDN

SEPTEMBER 12, 2019

Well, according to HTTP Archive , as of June 1, 2019 the average desktop page is 1,896.8 KeyCDN’s Cache Enabler plugin is fully compatible the HTML attributes that make images responsive. It also allows for additional control over the caching of your images as well as hotlink protection.

Social Media 106

Social Media Media Google Website 106

KeyCDN

JANUARY 31, 2019

With Bucharest being the capital and largest city of Romania, it makes for a great edge server location. However, now with the Bucharest edge server in production, it helps further close the gap between visitors who live in Romania and the nearest KeyCDN POP they have access to.

Internet 48

Internet Internet Ecommerce Speed 48

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. As in previous parts, code examples use the Stack Overflow 2010 database on SQL Server 2019 CU 16 with the following additional nonclustered index: CREATE INDEX [ IX dbo.

Cache 54

Cache Servers Database Performance 54

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 Testing Storage Servers 98

SQL Performance

MAY 20, 2022

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. Imagine someone handing you a query written for an unknown SQL Server database and asking you to identify parameterizable constants. usecounts , CP.

Cache 55

Cache Database Servers Testing 55

SQL Performance

APRIL 27, 2020

Many of the newer features we have in SQL Server were initially launched in Azure SQL Database, including (but not limited to) Always Encrypted, Dynamic Data Masking, Row Level Security, and Query Store. There is a lot of awesome technology involved with Hyperscale in how it is architected to use SSD-based caches and page servers.

Azure 55

Azure Database Serverless Hardware 55

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

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

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

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

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 59

Website Servers Code Best Practices 59

SQL Performance

APRIL 8, 2019

These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. This 14nm first-generation AMD EPYC 7551 processor has 32 cores and 64 threads, and it works in one or two-socket servers. The L3 cache size is 64MB. The L3 cache size is 64MB. AMD EPYC 7551 Details.

Azure 42

Azure Virtualization Storage Benchmarking 42