SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. In each of the deployment models, the role of the database administrator is to make sure that SSRS is stable, dependable, and recoverable.

Tuning 67

Tuning Servers Database Best Practices 67

Smashing Magazine

NOVEMBER 2, 2021

PWAs have been around for over five years, yet native applications outnumber them both in the quantity ratio and how many times users download them. This isn’t the case like with native applications whose success is at times predefined by the number of downloads. These multiple “heads” are attached to the backend and database.

Code 74

Code Cache Retail Mobile 74

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). In addition, there are fewer resources, plugins, libraries, third-party tools, and sources of support available than for other, more established database systems.

Open Source 52

Open Source Servers Storage Scalability 52

Percona

MAY 2, 2023

As a MongoDB user, it’s crucial to ensure that your data is safe and secure in the event of a disaster or system failure. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? mongodump --host=mongodb1.example.net

Best Practices 52

Best Practices Database Storage Servers 52

Dynatrace

AUGUST 12, 2019

With OneAgent installed on an application server, Davis, the Dynatrace AI causation engine, continuously analyzes all database statements within the context of your applications. Now, with Oracle database insights, we’re going even deeper, giving you visibility into what’s going on in the database layer.

Database 127

Database Metrics Cache Servers 127

Percona

APRIL 24, 2023

The urge to create more and more indexes is found to be causing severe damage in many systems. Many times, removing indexes is what we should be doing first before considering any new indexes for the benefit of the entire system. This post is about PostgreSQL, but most of the problems also apply to other database systems.

Tuning 128

Tuning Cache Storage Database 128

Percona

APRIL 6, 2023

PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. However, as the size of your database grows, it can become challenging to manage and optimize its performance. Pgpool-II This is where the pgpool-II comes in.

Cache 116

Cache Open Source Benchmarking Database 116

Percona

AUGUST 8, 2023

As such, one of the more common questions I get from my clients is whether or not their system will be able to endure an anticipated load increase. Hardware considerations The first thing we have to consider here is the resources that the underlying host provides to the database. Let’s take a look at each common resource.

Traffic 90

Traffic Cache Monitoring Database 90

Percona

MAY 10, 2023

I have seen many Linux Performance engineers looking at the “IOWait” portion of CPU usage as something to indicate whenever the system is I/O-bound. IOWait is completely gone and now this system does not look I/O-bound at all! Because of this accounting, other interesting behaviors are possible.

Cache 143

Cache Monitoring Open Source Processing 143

Percona

APRIL 3, 2023

Object identifiers (OIDs) are used internally by PostgreSQL as primary keys for various system tables. oid_test" SET WITHOUT OIDS; ALTER TABLE postgres=# c abs_test You are now connected to database "abs_test" as user "postgres". Type OID represents an object identifier. postgres=# ALTER TABLE "public"."oid_test"

C++ 103

C++ Database Cache Storage 103

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

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Amazon SQS: The Amazon Simple Queue Service enables users to decouple and scale microservices, serverless applications, and distributed systems, reducing both IT overhead and total complexity.

Serverless 279

Serverless AWS Lambda Storage 279

The Netflix TechBlog

OCTOBER 29, 2020

remotely configurable files that get downloaded to the device. Disk cache Of course, network connectivity may not always be available so downloaded rule sets need to be cached to disk. For this, we’re using SQLDelight along with it’s Android and Native Database drivers for Multiplatform persistence.

Mobile 279

Mobile Cache Network Architecture 279

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. how much data does the browser have to download to display your website) and resource usage of the hardware serving and receiving the website.

Website Performance 73

Website Performance Website Energy Performance 73

Percona

APRIL 7, 2023

I’ve used a fourth instance to host a PMM server to monitor servers A and B and used the data collected by the PMM agents installed on the database servers to compare performance. That’s a heritage of the LAMP model when the same server would host both the database and the web server.

Tuning 137

Tuning Cache Servers Benchmarking 137

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. HammerDB has graphical and command line interfaces for the Windows and Linux operating systems. Why HammerDB was developed.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.” – [link]. The Back Story.

Servers 90

Servers Media Cache Storage 90

Dynatrace

OCTOBER 21, 2020

This is a great example of how valuable Dynatrace is for diagnosing performance or scalability issues, and a great testimony that we at Dynatrace use our own product and its various capabilities across our globally distributed systems. One of them being a small cache that would have brought the initial startup time down by about 95%.

Code 242

Code Cloud Engineering Java 242

Smashing Magazine

AUGUST 3, 2023

Download Time of HTML This is the time it takes to download the page’s HTML file. You need to beware of large HTML files or slow network connections because they can lead to longer download times. Fetching And Decoding Images This is the time taken to fetch, download, and decode images, particularly the largest contentful image.

Performance 74

Performance Cache Traffic Metrics 74

Percona

MARCH 28, 2023

Every database system has to ensure durability and reliability. The same data, in the form of pages inside the Wiredtiger cache, are also marked dirty. At every checkpoint interval (Default 60 seconds), MongoDB flushes the modified pages that are marked as dirty in the cache to their respective data files (both collection-*.wt

Hardware 89

Hardware C++ Storage Cache 89

Percona

APRIL 17, 2023

In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. 25.84 - Total 21.04

Best Practices 52

Best Practices Design Tuning Database 52

Percona

FEBRUARY 1, 2023

PostgreSQL is a fantastic database, but if you’re storing images, video, audio files, or other large data objects, you need to “toast” them to get optimal performance. This process is done automatically and does not significantly impact how the database is used.

Storage 92

Storage Scalability Strategy Performance 92

Dynatrace

NOVEMBER 13, 2020

With Dynatrace, you get end-to-end visibility into each user action, from the user interaction triggered on the mobile device, through the maze of cloud and on-premises services, down to the database statement. This flushes the cache on the Dynatrace Cluster; you should see events in the web UI shortly thereafter. What’s next.

Code 172

Code Mobile Monitoring Infrastructure 172

Alex Russell

APRIL 29, 2021

After 20 years of neck-in-neck competition, often starting from common code lineages, there just isn't that much left to wring out of the system. Consistent improvement is the name of the game, and it can still have positive impacts, particularly as users lean on the system more heavily over time. Media Session API. Keyboard Lock API.

Media 145

Media Games Education Engineering 145

SQL Performance

MARCH 30, 2021

I used the public Stack Overflow 2013 database ( download details ). It can be downloaded at the same link. A parallel query might start out requesting DOP 8, but be progressively downgraded to DOP 4, DOP 2, and finally DOP 1 due to a lack of system resources at that moment. ( PostTypeId ASC , CreationDate ASC. )

Cache 98

Cache Servers Operating System Processing 98

Smashing Magazine

OCTOBER 26, 2018

WordPress core developers used a system of hooks which allowed other developers to modify or extend certain functionalities. It’s an all-in-one system that is equipped with a working admin interface; it manages database connection, and has a bunch of useful APIs exposed that handle user authentication, routing, and more.

Cache 78

Cache Website Speed Database 78

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. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

Enprowess

MARCH 4, 2018

Basically when group of servers and other resources act like a single system and enable high availability is termed as “Clustering”. Here are some basics/rules : All nodes should be pointing to same Liferay database. Enable cluster link for cache replication. On Node 2 download the document.

Cache 52

Cache Transportation Media Traffic 52

SQL Server According to Bob

JANUARY 11, 2020

​​ Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Servers 40

Servers Cache Database Media 40

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. One way to verify a column’s number of distinct values is by querying the pg_stats view in our database. Download Percona Distribution for PostgreSQL Today!

Best Practices 91

Best Practices Tuning Database Testing 91

MachMetrics

FEBRUARY 22, 2019

You must also take into consideration whether your site is using a Content Management System like WordPress or Drupal. This is because, with a CMS, the server is responsible for loading the database, grabbing content, deciphering the output of elements on the page, and finally, sending this to the website user. Number of Resources.

Speed 56

Speed Metrics Website Cache 56

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 fastest Androids predictably remain 18-24 months behind, owing to cheapskate choices about cache sizing by Qualcomm, Samsung Semi, and all the rest. The Moto G4 , for example. Is that a lot?

Performance 124

Performance Network Cache Metrics 124

Smashing Magazine

NOVEMBER 30, 2021

It’s the reason why I was able to become a developer, but every time someone visits a WordPress site out of the box, it has to make a call to a database, grabs some content, mash it into some templates, generate HTML and ship that back to the browser. I built my career on WordPress. That’s a really cool thing.

Technology 94

Technology Technology Servers Code 94

The Netflix TechBlog

MARCH 6, 2019

Mounting object storage in Netflix’s media processing platform By Barak Alon (on behalf of Netflix’s Media Cloud Engineering team) MezzFS (short for “Mezzanine File System”) is a tool we’ve developed at Netflix that mounts cloud objects as local files via FUSE. Disk Caching? — ? Regional caching? —?Netflix Replays? —?More

Media 214

Media Storage Processing Cache 214

Smashing Magazine

JANUARY 6, 2020

Download The Checklist (PDF, Apple Pages, MS Word). You can also just download the checklist PDF (166 KB) or download editable Apple Pages file (275 KB) or the.docx file (151 KB). PRPL stands for Pushing critical resource, Rendering initial route, Pre-caching remaining routes and Lazy-loading remaining routes on demand.

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 7, 2019

Download The Checklist (PDF, Apple Pages, MS Word). You can also just download the checklist PDF (166 KB) or download editable Apple Pages file (275 KB) or the.docx file (151 KB). While download times are critical for low-end networks, parse times are critical for phones with slow CPUs. Assets Optimizations. Quick Wins.

Performance 104

Performance Cache Network Metrics 104

High Scalability

NOVEMBER 25, 2019

He and his colleagues spend their productive hours scaling large distributed file systems. Our only option was to roll up our sleeves and build basic cloud file system components such as object store ourselves. Edge caching. Nginx for disk based caching. Java used to power core file system code. Introduction.

Architecture 52

Architecture Cache Azure Storage 52