SQL Performance

JANUARY 20, 2022

All through my career as a data professional, both inside Microsoft and as a consultant, I’ve found one of the most misunderstood parts of a SQL Server database is the transaction log. Performance issues from repeated shrinking of the transaction log. Basic Terminology Around Logging.

Servers 54

Servers Database Architecture Performance 54

Dynatrace

JULY 12, 2022

Several team members had to pore through logs, metrics, and other data to identify issues. “We The platform might identify, for example, that a SQL database “leverages [a particular] node when we do our Tlog [transaction log] backups,” he says. “We Previously, Park ‘N Fly had to manually troubleshoot.

Innovation 216

Innovation Infrastructure DevOps Azure 216

Percona

JUNE 23, 2023

It does not follow the SQL Standard as closely as other databases, and some useful functions such as MERGE() are missing. PostgreSQL has enjoyed a reputation of being the open source database closest to the SQL Standard, but close might not be good enough for you. The server, client, connectors, etc.,

Database 121

Database Transportation Servers Cloud 121

The Netflix TechBlog

FEBRUARY 25, 2021

Graph i QL: Auto-generated test GUI for the Star Wars API Our experience has led to an architecture with a number of best-practices for teams interested in GQLMS as a platform for rapid development. Tables and views could be modified within a single transaction such that the changes to the exposed GraphQL schema happened atomically.

Database 201

Database Entertainment Infrastructure Architecture 201

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. pt-summary --user=root [?2004l# virtual = 2.2G

Cache 101

Cache Database Virtualization Servers 101

IO River

NOVEMBER 15, 2023

For instance, let's say you operate an e-commerce site and you've noticed a pattern of fraudulent transactions originating from a particular IP range. OWASP provides a baseline defense against the most critical web application security risks, such as SQL injection, cross-site scripting, and more.‍What How do you stay ahead?

Traffic 52

Traffic Network Logistics Architecture 52

Percona

MAY 15, 2023

Also, in the case of multi-Primary, the writes will be distributed by transaction. If I have a node that manages only the items, another one the orders, and another one the payments, I will need to have my solution able to deal with distributed transactions, each of which needs to certify and verify other nodes’ data.

Traffic 125

Traffic Scalability Database Servers 125

Percona

AUGUST 30, 2023

Hot backups vs. cold backups: A hot backup — used to minimize downtime and ensure data availability for critical applications — allows you to create a copy of a database while the system is still actively serving user requests and processing transactions. This includes both data and log backups.

Database 90

Database Hardware Open Source Strategy 90

IO River

NOVEMBER 2, 2023

You're in the driver's seat, dictating what constitutes a threat for your particular application.‍For instance, let's say you operate an e-commerce site and you've noticed a pattern of fraudulent transactions originating from a particular IP range. After WAF evaluates an incoming request based on these rules, it takes specific actions.

Traffic 40

Traffic Network Logistics Architecture 40

Percona

AUGUST 1, 2023

Because of its NoSQL origin and document architecture design, MongoDB is much more flexible and scalable than SQL databases such as MySQL. As a result, typically, much more data is stored in MongoDB than in traditional SQL databases. Percona Server for MongoDB has offered at rest encryption for the MongoDB Community Edition.

Best Practices 41

Best Practices Transportation Open Source Traffic 41

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations.

Servers 40

Servers Cache Media Hardware 40

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability 40

Availability Servers Hardware Benchmarking 40

The Morning Paper

FEBRUARY 23, 2020

Our approach differs substantially by (1) providing economic incentives for data to be contributed and integrated into existing schemas, (2) offering a SQL interface instead of graph based approaches, (3) including the computational and storage infrastructure in the architectural vision. SQL processing for publishers.

Blockchain 94

Blockchain Internet Internet IoT 94

HammerDB

OCTOBER 12, 2018

Historically MySQL has been positioned for supporting web-based applications this is in contrast to enterprise based database workloads that have been served by commercial databases such as Oracle, Db2 and SQL Server. Make sure that the I/O that is able to keep up with writing to the redo log. 10 rows in set (0.02

Best Practices 40

Best Practices Scalability Performance C++ 40