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

All Things Distributed

MARCH 5, 2012

By Werner Vogels on 05 March 2012 02:01 PM. AWS today announced a substantial price drop from March 1, 2012 for many of the Amazon EC2, Amazon RDS, and Amazon ElastiCache instances types around the world. Amazon ElastiCache customers will see their prices drop by up to 10%, depending on their cache node types. Comments ().

AWS 111

AWS Innovation Scalability Cache 111

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

All Things Distributed

SEPTEMBER 28, 2012

By Werner Vogels on 28 September 2012 06:00 PM. In 2000 an improvement on the original Bloom filters called Counting Bloom Filters was published as part of the Summary Cache protocol. All Things Distributed. Werner Vogels weblog on building scalable and robust distributed systems. Comments ().

Cache 86

Cache AWS Scalability Network 86

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

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 124

Performance Network Cache Metrics 124

All Things Distributed

NOVEMBER 17, 2012

By Werner Vogels on 17 November 2012 11:00 PM. The Andrew File System (AFS) was developed at CMU and was much more than just a distributed file systems and had a very interesting caching and volume replication architecture. All Things Distributed. Werner Vogels weblog on building scalable and robust distributed systems. Comments ().

Systems 88

Systems Government Cache Scalability 88

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

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 Cache Servers Software Engineering 40

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

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

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 57

Website Servers Code Best Practices 57

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

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

All Things Distributed

JUNE 21, 2017

Today, I'm excited to announce the general availability of Amazon DynamoDB Accelerator (DAX) , a fully managed, highly available, in-memory cache that can speed up DynamoDB response times from milliseconds to microseconds, even at millions of requests per second. Adding caching when your app is already experiencing load is not easy.

Speed 123

Speed Cache Latency AWS 123

All Things Distributed

MAY 13, 2012

By Werner Vogels on 14 May 2012 12:01 AM. Query String based Caching: the ability to include query string parameters as part of the objects cache key. URL based configuration: the ability to configure cache behaviors based on URL path patterns. All Things Distributed. Dynamic Content Support in Amazon CloudFront.

Cache 118

Cache Latency AWS Website 118

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 139

Ecommerce Website Government Internet 139

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 197

Database Traffic Transportation Open Source 197

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 212

Database Traffic Transportation Open Source 212

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 77

AWS Media Cache Operating System 77

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 130

Internet Internet AWS Performance 130

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 167

Scalability Database Ecommerce Latency 167