article thumbnail

Hybrid Buffer Pool in SQL Server 2019

SQL Shack

This article explores the Hybrid Buffer Pool feature available in the SQL Server 2019. Introduction SQL Server uses Dynamic Random Access Memory (D-RAM) buffer pool for caching data pages retrieved from the disk. The buffer cache stores the page and writes back to disk only if it is modified.

Servers 93
article thumbnail

WebP Caching has Landed!

KeyCDN

We’re happy to announce that WebP Caching has landed! We offer both a one click solution with no change required on your origin server as well as an approach where you can deliver the WebP assets from your origin server. How Does WebP Caching Work? It’s all about the accept header sent from the client.

Cache 81
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Year in Web Performance: 2019

MachMetrics

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.

article thumbnail

ScaleGrid Fully Managed Hosting for Redis™ Now Available on Azure

Scalegrid

October 2, 2019 – ScaleGrid, a rapidly growing leader in the Database-as-a-Service (DBaaS) space, has just launched their new fully managed Hosting on Azure for Redis™ service. The demand for Redis™ is skyrocketing across dozens of use cases, particularly for cache, queues, geospatial data, and high speed transactions.

Azure 100
article thumbnail

USENIX SREcon APAC 2022: Computing Performance: What's on the Horizon

Brendan Gregg

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.

article thumbnail

Simple Parameterization and Trivial Plans — Part 2

SQL Performance

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
article thumbnail

USENIX SREcon APAC 2022: Computing Performance: What's on the Horizon

Brendan Gregg

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.