Scalegrid

APRIL 16, 2020

Where you decide to host your cloud databases is a huge decision. But, if you’re considering leveraging a managed databases provider, you have another decision to make – are you able to host in your own cloud account or are you required to host through your managed service provider? Where to host your cloud database?

Cloud 242

Cloud Azure AWS Database 242

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. TB)) for storage of database tablespaces and logging. Database: MySQL 8.0.31

Performance 54

Performance Benchmarking Cache Storage 54

SQL Performance

JANUARY 11, 2021

all_columns ; The prepared statement from the application looked like this (as seen in the plan cache): ( @P0 varchar ( 8000 ) ) SELECT * FROM dbo.TheThings WHERE TypeID = @P0. We'd need to make it recompile, without adding hints to the query, turning on trace flags, or changing database settings. Let's try sp_prepare.

Cache 59

Cache Tuning Database Performance 59

Percona

AUGUST 8, 2023

Hardware considerations The first thing we have to consider here is the resources that the underlying host provides to the database. Global caches like the InnoDB buffer pool and MyISAM key cache and session-level caches like the sort buffer, join buffer, random read buffer, etc. Do these queries use more caches?

Traffic 87

Traffic Cache Monitoring Database 87

SQL Server According to Bob

JANUARY 26, 2017

Transparent Data Encryption (TDE) is a feature that was introduced in SQL Server 2008 (and is also available for Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse) with the purpose of encrypting your data at rest. That is to ensure your database is encrypted at the file level.

Servers 40

Servers Database Azure Cache 40

Dynatrace

APRIL 21, 2022

Once you have and understand this data, you can identify issues, find opportunities for improvement, and eliminate risks before you go through a costly migration exercise. Too much data requested from a database. Missing caching layers. Too many fine-grained services leading to network and communication overhead.

Azure 187

Azure Monitoring Virtualization Metrics 187

All Things Distributed

OCTOBER 2, 2017

Today marks the 10 year anniversary of Amazon's Dynamo whitepaper , a milestone that made me reflect on how much innovation has occurred in the area of databases over the last decade and a good reminder on why taking a customer obsessed approach to solving hard problems can have lasting impact beyond your original expectations.

Internet 130

Internet Internet AWS Performance 130