SQL Performance

MAY 16, 2019

For SQL Server 2012 and earlier, this means 5 extra bytes per row are included in the data size calculation: One byte for an internal bit flag, and four bytes for the uniquifier (used in the calculation even for unique indexes, which do not store a uniquifier ). . [ SQL Server 2012. spt_values AS SV ; Plan Caching.

Cache 67

Cache Servers Testing Storage 67

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 cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively. low-end Androids have finally caught up to the iPhone 5 from 2012. The Moto G4 , for example.

Performance 127

Performance Network Metrics Cache 127

All Things Distributed

SEPTEMBER 21, 2012

By Werner Vogels on 21 September 2012 06:00 PM. It is a simple concept, originally introduced for handling cache consistency, but it is a technique you find back in many modern systems, for example those those that achieve consistency using lock servers. All Things Distributed. Back-to-Basics Weekend Reading - Leases. Comments ().

AWS 66

AWS Media Cache Operating System 66

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. References [1] Das, Shirshanka, et al. “ All aboard the Databus!:

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. References [1] Das, Shirshanka, et al. “ All aboard the Databus!:

Database 209

Database Traffic Transportation Open Source 209

Brendan Gregg

FEBRUARY 28, 2023

Titus, the Netflix container management platform, is now open source,” [link] Apr 2018 - [Cutress 19] Dr. DDR6: Here's What to Expect in RAM Modules,” [link] Nov 2020 - [Salter 20] Jim Salter, “Western Digital releases new 18TB, 20TB EAMR drives,” [link] Jul 2020 - [Spier 20] Martin Spier, Brendan Gregg, et al.,

Performance 103

Performance Latency Cache Virtualization 103

All Things Distributed

OCTOBER 2, 2017

With these goals in mind, In January, 2012 we launched Amazon DynamoDB , our cloud-based NoSQL database service designed from the ground up to support extreme scale, with the security, availability, performance and manageability needed to run mission-critical workloads. Manageable – The service would need to be easy to manage and operate.

Internet 113

Internet Internet AWS Performance 113

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. The aim is to reduce compilations by increasing cached plan reuse. configname = 'cost threshold for parallelism' , @configvalue = 50 ; RECONFIGURE ; Example code: -- Clear the cache of plans for this database.

Cache 61

Cache Servers Database Code 61

All Things Distributed

JANUARY 18, 2012

By Werner Vogels on 18 January 2012 07:00 AM. Without this ability, engineers often have to carefully manage caching systems to ensure they can achieve low-latency and predictable performance as their workloads scale. Werner Vogels weblog on building scalable and robust distributed systems. Amazon DynamoDB â?? Comments ().

Scalability 164

Scalability Database Ecommerce Latency 164

Tim Kadlec

JUNE 21, 2022

HTTP/3 work started in 2012 with Google working on QUIC, adopted by IETF in 2017, RFC’s published in June 2022. The browser stores alt-svc info in alt-svc cache. At #SmashingConf San Francisco , Robin Marx gave a presentation about HTTP/3. Here are my notes. All major browsers support thanks to iOS starting with version 16.

Network 65

Network Mobile Google Cache 65

Smashing Magazine

AUGUST 20, 2021

In 2012, Dave Cole published a post on How we build CMS free websites. When we talk about static site generators, incremental regeneration, or instant cache invalidation, it’s enough to make the layman’s eyes glaze over. Jekyll took this a step further by providing more structure around the content. to manage the content.

Ecommerce 140

Ecommerce Website Government Internet 140

SQL Performance

APRIL 18, 2022

It’s important to remember the plan must be cached. Requesting an estimated plan from SSMS does not cache the plan produced (since SQL Server 2012). Once the plan is cached, the StatementParameterizationType appears in the usual places, including via sys.dm_exec_query_plan. Dynamic Management Objects.

Cache 58

Cache Servers Database Testing 58

SQL Performance

MAY 20, 2022

Let’s look at the plan cache: SELECT. The parameter data types are still different, so separate plans are cached and no plan reuse occurs. There is a partial list of the syntax elements that prevent simple parameterization in Appendix A of the Microsoft Technical Paper Plan Caching and Recompilation in SQL Server 2012.

Cache 55

Cache Database Servers Testing 55

Smashing Magazine

JUNE 30, 2021

In terms for performance, these phones have plateaued at the performance of a 2012 iPhone. Low-end phones on the other hand are getting cheaper , making the mobile internet accessible to demographics that previously maybe couldn’t afford it.

Games 145

Games Architecture Code C++ 145

SQL Server According to Bob

JUNE 3, 2016

Use SQL Server Management Studio (SSMS) or your favorite query editor to connect to a SQL Server 2012 or 2014 instance. Note: You may need to execute the dbcc a second time so buffer cache is hot, eliminating I/O sub-system variants. Paste the script below in a new query window. or newer release.

Hardware 40

Hardware Servers Cache Software Engineering 40

SQL Performance

JUNE 21, 2019

Prior to SQL Server 2012, the maximum server memory value only applied to the bufferpool, so customers needed to limit the amount of memory the bufferpool could use to save memory for the operating system and other processes. I tend to recommend increasing this value to a higher number after examining the Plan Cache.

Servers 49

Servers Azure Hardware Database 49

Brendan Gregg

FEBRUARY 28, 2023

Titus, the Netflix container management platform, is now open source,” [link] , Apr 2018 [Cutress 19] Dr. DDR6: Here's What to Expect in RAM Modules,” [link] , Nov 2020 [Salter 20] Jim Salter, “Western Digital releases new 18TB, 20TB EAMR drives,” [link] , Jul 2020 [Spier 20] Martin Spier, Brendan Gregg, et al.,

Performance 52

Performance Latency Cache Virtualization 52

SQL Server According to Bob

JUNE 3, 2016

“SQL Server 2016 running on the same hardware as SQL Server 2014, 2012, 2008, 2008 R2 or 2005 uses fewer resources and executes a wide range of workloads faster. The following table is taken from an ASP.NET, session state cache, stress test. ” – Bob Dorr, Principle Engineer SQL Server Support. .”

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Performance

JULY 16, 2019

This situation was so bad that Microsoft offered a 25% discount on the cost of SQL Server processor core licenses for SQL Server 2012 and SQL Server 2014, if you ran on qualifying AMD Opteron processors with six or more cores. They will also have up to 256MB of L3 cache per processor.

Servers 46

Servers Hardware Architecture Retail 46

SQL Performance

AUGUST 23, 2019

There have been major improvements since the first appearance of the batch mode execution engine in SQL Server 2012. The SQL Server batch mode implementation of a Bloom filter is optimized for modern CPU cache architectures and is known internally as a complex bitmap. Bitmap Choice.

Servers 75

Servers Engineering Efficiency Retail 75

Smashing Magazine

APRIL 9, 2019

They’d take the hit for the first site to use the file, but then it would sit in their local browser cache and downloads could be skipped for each subsequent site. Let’s imagine that it’s 2012 and everyone is using the brand new jQuery 1.8. What Could Go Wrong? file hosted as part of their own website on their own server.

Website 59

Website Servers Code Best Practices 59

Percona

JUNE 4, 2023

GA 11 April 2012 5.5.23 MyISAM is modified with segmented key caches, the default temporary table storage engine is Aria (which is a crash-safe MyISAM), the FederatedX engine is a modified FEDERATED engine, and there are more: CONNECT, Mroonga, OQGRAPH, Sequence, SphinxSE, SPIDER, TokuDB and of course MyRocks. GA 28 April 2011 5.5.11-20.2

Open Source 52

Open Source Servers Storage Scalability 52

Speed Curve

JULY 8, 2024

Way back in 2012, Harry Shum (then EVP of Technology and Research at Microsoft) said : "Two hundred fifty milliseconds, either slower or faster, is close to the magic number now for competitive advantage on the Web." This is often referred to as a cold cache. Yet only 1 out of the 20 pages I looked at had an efficient cache policy.

Speed 138

Speed Cache Benchmarking Metrics 138

All Things Distributed

DECEMBER 18, 2012

The Back-to-Basics Readings of 2012. By Werner Vogels on 18 December 2012 10:00 PM. Jul 4 - Leases: An efficient fault-tolerant mechanism for distributed file cache consistency , Gray, Cary, and David Cheriton, Vol. Sep 21 - Leases: An Efficient Fault-Tolerant Mechanism for Distributed File Cache Consistency , Cary G.

Operating System 134

Operating System Cache AWS Scalability 134