Dynatrace

AUGUST 30, 2019

Reducing CPU Utilization to now only consume 15% of initially provisioned hardware. Impacting Server-Side Requests: Dynatrace allows you to drill into your server-side requests to understand why your business logic is executing slow or fails. Impressive results I have to say!

Cache 214

Cache Database Architecture Government 214

Scalegrid

JULY 13, 2020

The $47,500 licensing costs for Oracle Enterprise Edition is only for one CPU core, that ultimately has to be multiplied with the actual number of cores on the physical server. Oracle support for hardware and software packages is typically available at 22% of their licensing fees. So Which Is Best? . $104,310.

Open Source 244

Open Source Tuning C++ Database 244

Percona

JUNE 22, 2023

Defining high availability In general terms, high availability refers to the continuous operation of a system with little to no interruption to end users in the event of hardware or software failures, power outages, or other disruptions. Load balancers can detect when a component is not responding and put traffic redirection in motion.

Availability 132

Availability Database Open Source Hardware 132

Percona

JUNE 12, 2023

The immediate (working) goal and requirements of HA architecture The more immediate (and “working” goal) of an HA architecture is to bring together a combination of extensions, tools, hardware, software, etc., Load balancing : Traffic is distributed across multiple servers to prevent any one component from becoming overloaded.

Architecture 124

Architecture Availability Open Source Healthcare 124

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. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. A setting of 100 determines it to swap aggressively to disk.

Best Practices 52

Best Practices Design Tuning Database 52

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. However, simply deploying a monitoring tool is not enough; you need to know which Key Performance Indicators (KPIs) to monitor to gain insights into your MySQL server’s health and performance.

Performance 136

Performance Monitoring Traffic Database 136

All Things Distributed

AUGUST 16, 2012

The best practices that we are collecting in the AWS Economics Center are there to help our customers get a total view on their IT cost such that they can accurately compare on-premise and cloud. 3-Year Heavy Utilization Reserved Instances offer the maximum savings over equivalent servers deployed in an on-premises environment.

AWS 99

AWS Hardware Traffic Best Practices 99

KeyCDN

AUGUST 15, 2019

Bottlenecks can occur, for example, if you have a sudden surge in traffic that your servers are not equipped to handle. Prepare the testing environment: Make sure your hardware and network configurations closely reflect real world conditions. There are many common issues that performance testing can uncover, such as bottlenecks.

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55

Scalegrid

AUGUST 30, 2024

Authentication Mechanisms in RabbitMQ RabbitMQ provides several authentication mechanisms to ensure the security of user-server connections, such as using a combination of username and password or employing X.509 When an authentication attempt fails in RabbitMQ, it terminates connections, and error messages are recorded in server logs.

Transportation 130

Transportation Virtualization Strategy Storage 130

The Morning Paper

MARCH 1, 2020

A modern commodity server can contain up to 1TB of RAM, and Lambda functions can use as little as 128MB. So you need up to 8000 functions on a server to fill the RAM (more in practice due to soft allocation). This also makes any solution very sensitive to per-function (per isolation unit) overheads.

Virtualization 101

Virtualization Serverless Lambda AWS 101

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. 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. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS. Statistics.

Servers 49

Servers Azure Hardware Database 49

Percona

OCTOBER 18, 2023

Our goal with this post is to equip you with a comprehensive understanding of the steps, best practices, and pros and cons to ensure a smooth — and successful — transition to an open source database environment. Evaluating your hardware requirements is another vital aspect of resource allocation.

Open Source 111

Open Source Database Hardware Strategy 111

Scalegrid

JANUARY 25, 2024

You will need to know which monitoring metrics for Redis to watch and a tool to monitor these critical server metrics to ensure its health. Connected_slaves provides information about replication status while Used_memory tracks utilized amount of server’s total capacity. You can pick a smart selection of relevant metrics from these.

Metrics 130

Metrics Monitoring Latency Cache 130

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level.

Best Practices 40

Best Practices Scalability Performance C++ 40

Percona

DECEMBER 27, 2023

AI and MLOps Kubernetes has become a new web server for many production AI workloads, focusing on facilitating the development and deployment of AI applications, including model training. It comprises numerous organizations from various sectors, including software, hardware, nonprofit, public, and academic.

Cloud 113

Cloud Open Source Strategy Best Practices 113

All Things Distributed

APRIL 5, 2012

Troy: We moved our service from internal servers to AWS. In addition to using Edmodo to engage students in classroom activities, teachers all over the world build profile pages on Edmodo, which they use to discover and share content, meet and stay in contact with other educators, and best practices and top resources.

Innovation 112

Innovation AWS Education Network 112

HammerDB

OCTOBER 8, 2018

This limitation is at the database level rather than the hardware level, nevertheless with up to date hardware (from mid-2018) PostgreSQL on a 2 socket system can be expected to deliver more than 2M PostgreSQL TPM and 1M NOPM with the HammerDB TPC-C test. . CPUs which run at the same hardware frequency: 0. timezone = 'GB'.

Best Practices 40

Best Practices Scalability Performance Hardware 40

Percona

JULY 7, 2023

In general terms, to achieve HA in PostgreSQL, there must be: Redundancy: To ensure data redundancy and provide continuous performance when a primary server fails, multiple copies of the database reside in replica servers. When the primary server fails, a standby server takes over as the new primary.

Availability 98

Availability Open Source Architecture Database 98

Percona

NOVEMBER 9, 2023

Kubernetes can be complex, which is why we offer comprehensive training that equips you and your team with the expertise and skills to manage database configurations, implement industry best practices, and carry out efficient backup and recovery procedures.

Efficiency 117

Efficiency Cloud Healthcare Open Source 117

Percona

SEPTEMBER 1, 2023

This results in expedited query execution, reduced resource utilization, and more efficient exploitation of the available hardware resources. Reduced Resource Usage Optimizing resource-intensive queries and configurations can lead to a reduced burden on your server. Indexing is another powerful technique for query optimization.

Tuning 52

Tuning Database Performance Hardware 52

CSS - Tricks

AUGUST 18, 2020

Even if you render components on the server and hydrate them on the client, it still churns because component hydration is computationally expensive. When even a bit of React can be a problem on devices slow and fast alike, using it is an intentional choice that effectively excludes people with low-end hardware. I think JSX is great.

Performance 104

Performance Mobile Servers Code 104

The Morning Paper

FEBRUARY 18, 2020

Here are the three big directional bets that align with the three main areas cited by the authors: We will train in the cloud , where its possible to take advantage of managed infrastructure well suited to large amounts of data, spiky resource usage, and access to the latest hardware. Will we like them more than we like stored procedures?

Government 95

Government Software Engineering Storage Database 95

ACM Sigarch

JULY 17, 2023

One such challenge has been the emergence of marginal defect-driven faults that are difficult to address solely using best practices in manufacturing test and screening. An example of a specification is the correct operation of the hardware of a microprocessor. Each fault has a root cause. core lock-stepping).

Energy 52

Energy Hardware Best Practices Architecture 52

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 desktop machine (I won’t tell you the hardware details. There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use.

Servers 40

Servers Media Engineering Virtualization 40

Percona

JULY 26, 2023

When you have multiple copies of your data on different database servers — or even better, in different data centers worldwide — replication provides a high level of fault tolerance in case of a disaster. It is best practice to have an odd number of replica set members to maintain voting quorum.

Database 98

Database Servers Storage Strategy 98

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. 30.14% in the middle of the flame graph. Searching shows it was elsewhere as well for a total of 32.1%.

Speed 103

Speed Java AWS Virtualization 103

O'Reilly

OCTOBER 11, 2022

It’s possible to augment this basic process with OCR so the application can find data on paper forms, or to use natural language processing to gather information through a chat server. 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.

Games 141

Games Healthcare Processing Systems 141

Dotcom-Montior

JUNE 15, 2020

The censorship and monitoring of internet have evolved from anti-virus-like and firewall software to hardware security patches for all devices that uses internet. Message timestamps are also affected due to the time zone differences with the country where the VPN server is located.

Monitoring 52

Monitoring Performance Artificial Intelligence Internet 52

Percona

MAY 1, 2023

PostgreSQL performance optimization aims to improve the efficiency of a PostgreSQL database system by adjusting configurations and implementing best practices to identify and resolve bottlenecks, improve query speed, and maximize database throughput and responsiveness.

Tuning 52

Tuning Database Efficiency Performance 52

Smashing Magazine

APRIL 29, 2021

Device Pixel Ratio (DPR) represents how a CSS pixel is translated to physical pixels on a hardware screen. This is sent by the client, allowing the server to deliver an image format that is the best fit for the user. now includes an Image component with several of the above best practices baked in. Large preview ).

Media 145

Media Network Metrics Mobile 145

Abhishek Tiwari

JULY 12, 2018

These nodes and edges require a good amount of compute and storage which is typically distributed across a large number servers either running in the cloud or your own data center. A data pipeline is a software which runs on hardware. The software is error-prone and hardware failures are inevitable.

Latency 63

Latency Analytics Scalability Engineering 63

Dotcom-Montior

NOVEMBER 27, 2018

LoadView – Best Practices and Process. Analyzing server performance (CPU, memory, bandwidth, disk I/O) and database response times. Design your test without the hassle of managing hardware, giving you the ability to identify objectives and define a scenario by setting up a number of users and test duration.

Performance Testing 40

Performance Testing Strategy Testing Performance 40

VoltDB

MAY 2, 2017

We recently received a question from a customer who was looking for a quick way to repurpose some VoltDB production servers to create a disaster recovery site. Say you have five VoltDB servers in production, with k-factor=2, and no disaster site. You want to shift some of these servers to create a disaster recovery site.

Hardware 40

Hardware Database Servers Tuning 40

Percona

AUGUST 5, 2023

KEY partitioning KEY partitioning is similar to HASH partitioning, except that only one or more columns to be evaluated are specified, and the MySQL server provides its own hashing function. This approach is helpful when working with tables with many columns or when specific columns are frequently updated.

Strategy 40

Strategy Storage Database Best Practices 40

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. 30.14% in the middle of the flame graph. Searching shows it was elsewhere as well for a total of 32.1%.

Speed 52

Speed Java AWS Virtualization 52

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. 30.14% in the middle of the flame graph. Searching shows it was elsewhere as well for a total of 32.1%.

Speed 40

Speed Java AWS Virtualization 40

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40