2016 Availability Cache Database 
SQL Server According to Bob
NOVEMBER 8, 2016
Note: We received feedback that there was some confusion on us calling this functionality “tail of the log caching” because our documentation and prior history has referred to the tail of the log as the portion of the hardened log that has not been backed up. Create / Alter Database … LOG ON. Tail Of Log Caching.
SQL Performance
JUNE 5, 2019
Neither is ideal, and when you simply have too many queries asking for more memory than is available to grant, you’ll see RESOURCE_SEMAPHORE waits. Reminder: Do not run ALTER DATABASE <YourDBName> SET QUERY_STORE CLEAR; against your production database unless you want to remove everything from Query Store. ) ; GO.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
All Things Distributed
JUNE 20, 2017
The new AWS Asia Pacific (Hong Kong) Region will have three Availability Zones and be ready for customers for use in 2018. As a result, we have opened 43 Availability Zones across 16 AWS Regions worldwide. Since then, AWS has added two more PoPs in Hong Kong, the latest in 2016. In 2013, AWS opened an office in Hong Kong.
Alex Russell
MARCH 6, 2021
Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage.
Percona
JANUARY 17, 2019
On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. Aurora Parallel Query response time (for queries which can not use indexes) can be 5x-10x better compared to the non-parallel fully cached operations. The second and third run used the cached data.
Adrian Cockcroft
JANUARY 29, 2023
I presented this analysis of response time distributions talk in 2016 — at Microxchg in Berlin ( video ). A later version of the slides is included in my Microservices Workshop deck from later that year, slides 168–200 ( pdf , keynote are available in GitHub.com/adrianco/slides ). I’ve been thinking about this for a long time.
Percona
JUNE 4, 2023
Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.
Expert insights. Personalized for you.
40 
Let's personalize your content