SQL Performance

APRIL 27, 2020

Azure SQL Database is Microsoft's database-as-a-service offering that provides a tremendous amount of flexibility. It is built as part of the platform-as-a-service environment which provides customers with additional monitoring and security for the product. HyperScale Database. DTU Pricing Tier.

Azure 55

Azure Database Serverless Hardware 55

Dynatrace

SEPTEMBER 29, 2021

Container technology is very powerful as small teams can develop and package their application on laptops and then deploy it anywhere into staging or production environments without having to worry about dependencies, configurations, OS, hardware, and so on. Built-in monitoring. Needs third party tools for monitoring.

Open Source 294

Open Source Traffic DevOps Cloud 294

SQL Performance

JANUARY 23, 2020

The queues component of our methodology comes from Performance Monitor counters, which provide a view of system performance from a resource standpoint.". Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waiting queries mean waiting applications and users, and no one likes to wait!

Tuning 115

Tuning Servers Monitoring Hardware 115

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The percentage in degradation will vary depending on many factors {hardware, workload, number of tables, configuration, etc.}. Results for Percona Server for MySQL 8.0

Cache 103

Cache Hardware Servers Benchmarking 103

Percona

JANUARY 4, 2024

Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. Flexible location : Data files can reside within the MySQL data directory or an independent location, enabling finer control over storage management and performance tuning.

Storage 89

Storage Engineering Database Hardware 89

Percona

APRIL 17, 2023

The main objective of this post is to share my experience over the past years tuning MongoDB and centralize the diverse sources that I crossed in this journey in a unique place. The Linux default is usually 60 , which is not ideal for database usage. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices 52

Best Practices Design Tuning Database 52

Adrian Cockcroft

JUNE 21, 2022

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. We had specializations in hardware, operating systems, databases, graphics, etc.

Tuning 52

Tuning Benchmarking Engineering C++ 52

Alex Podelko

OCTOBER 20, 2016

From one side, it makes it easier to monitor and update / rollback systems that lowers performance-related risks. System’s configuration is not given anymore and often can’t be easily mapped to hardware. The dynamic architectures represent a major challenge for both monitoring and analysis.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

The Netflix TechBlog

AUGUST 30, 2021

Complementing the hardware is the software on the RAE and in the cloud, and bridging the software on both ends is a bi-directional control plane. When a new hardware device is connected, the Local Registry detects and collects a set of information about it, such as networking information and ESN.

Latency 213

Latency Traffic Transportation Hardware 213

Percona

AUGUST 5, 2023

Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. As the data is distributed into smaller partitions, the database engine only needs to scan relevant partitions, leading to faster query responses.

Strategy 40

Strategy Storage Database Best Practices 40

Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. Some of them are: MySQL Cluster: MySQL NDB Cluster is an in-memory database clustering solution developed by Oracle for MySQL.

Open Source 89

Open Source Storage Database Big Data 89

SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49

Servers Azure Hardware Database 49

Percona

AUGUST 30, 2018

One of the common ways to classify database workloads is whether it is “read intensive” or “write intensive”. Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as what techniques you can apply for performance optimization and scalability.

Benchmarking 47

Benchmarking Database Operating System Architecture 47

VoltDB

MAY 2, 2017

This has always been a supported configuration of VoltDB database replication. Here’s how we explain it in our Documentation: Support for different cluster sizes in passive Database Replication (DR). because they want to use a lower k- factor (even 0) on the replica cluster to lower hardware costs. Keeping the lights on.

Hardware 40

Hardware Database Servers Tuning 40

HammerDB

OCTOBER 12, 2018

Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance.

Best Practices 40

Best Practices Scalability Performance C++ 40

SQL Performance

MARCH 8, 2021

This can make it difficult to draw sound performance-tuning conclusions. The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo. This next example query uses the same database and index as before. A final example.

Servers 95

Servers Tuning Architecture Processing 95

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? SQL Server 2005 introduces the snapshot database feature for point-in-time databases ​​ and online DBCC operations.

Servers 40

Servers Cache Database Media 40

O'Reilly

NOVEMBER 28, 2023

If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” And there are tools for archiving and indexing prompts for reuse, vector databases for retrieving documents that an AI can use to answer a question, and much more. We’ll say more about this later.)

Open Source 108

Open Source Artificial Intelligence Google Infrastructure 108

O'Reilly

OCTOBER 11, 2022

However, one thing should be obvious: to fill a prescription, you need to access many different kinds of data, in many different databases. Andrew Ng , Christopher Ré , and others have pointed out that in the past decade, we’ve made a lot of progress with algorithms and hardware for running AI. Most are subject to privacy regulations.

Games 116

Games Healthcare Processing Retail 116

High Scalability

NOVEMBER 25, 2019

Chokepoint : Even sharded Berkeley DB was choking under the stress and there was a database crash with recovery taking hours, it had to be replaced. Automate schema management for some remaining databases. We do a production deploy every Wednesday and monitor new relic, exception reports daily for any anomalies. Cloud Platform.

Architecture 52

Architecture Cache Azure Storage 52