HammerDB

JUNE 27, 2022

It enables the user to measure database performance and make comparative judgements about database hardware and software. These factors meant that often when looking for database performance information, the results for a particular combination of software and hardware were not available. What is HammerDB? Why HammerDB was developed.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Brendan Gregg

MARCH 16, 2024

The x86-64 ABI documentation shows how a CPU register, %rbp, can be used as a "base pointer" to a stack frame, aka the "frame pointer." It was also a virtual machine that lacked low-level hardware profiling capabilities, so I wasn't able to do cycle analysis to confirm that the 10% was entirely frame pointer-based.

Java 145

Java Cache Google Hardware 145

Percona

APRIL 17, 2023

Operating System (OS) settings Swappiness Swappiness is a Linux kernel setting that influences the behavior of the Virtual Memory manager when it needs to allocate a swap, ranging from 0-100. 20-30% is a good general default for “dirty_ratio,” but on large-memory database servers, this can be a lot of memory.

Best Practices 52

Best Practices Design Tuning Database 52

HammerDB

FEBRUARY 25, 2021

To benchmark a database we introduce the concept of a Virtual User. When we have multiple CPU cores on both the benchmark client and database server it is crucial that these database sessions run independently of each other at the same time, in parallel. The following is an example from TPROC-C from SQL Server. select top 100.

Programming 67

Programming Benchmarking Virtualization C++ 67

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40

HammerDB

APRIL 19, 2023

Regardless of whether the computing platform to be evaluated is on-prem, containerized, virtualized, or in the cloud, it is crucial to consider several essential factors. There are several ways to find out this information with the easiest way being by referring to the documentation. and 8.0.32 HammerDB 4.5 to 8.0.32.

Performance 54

Performance Benchmarking Cache Storage 54

SQL Performance

JULY 3, 2019

A recent consulting engagement was focused on blocking issues inside of SQL Server that were causing delays in processing user requests from the application. Depending on which DMV you look at for SQL Server, a session can have a few different statuses. So, we had to dig in further. Understanding Session Status.

Servers 64

Servers Hardware Code Virtualization 64

HammerDB

NOVEMBER 22, 2021

include/server -I/opt/postgresql-14.1/include/internal The example shows a TPROC-C workload running with 4 Active Virtual Users. Further information on CPU and database metrics can be found in the documentation. git clone [link] cd pgsentinel/src opt/postgresql-14.1/pgsentinel/src$ I/opt/postgresql-14.1/include/server

Metrics 62

Metrics Benchmarking C++ Database 62

HammerDB

DECEMBER 5, 2020

First of all it has always been clear in the HammerDB documentation that the TPROC-C/TPC-C and TPROC-H/TPC-H workloads have not been ‘real’ audited and published TPC results instead providing a tool to run workloads based on these specifications. Instead all of the client servers are connecting to the TP monitor.

C++ 40

C++ Benchmarking Virtualization Open Source 40

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

Brendan Gregg

SEPTEMBER 5, 2017

Linux has been adding tracing technologies over the years: kprobes (kernel dynamic tracing), uprobes (user-level dynamic tracing), tracepoints (static tracing), and perf_events (profiling and hardware counters). There's a lot about Linux containers that isn't well documented yet, especially since it's a moving target.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Adrian Cockcroft

NOVEMBER 13, 2023

The carbon footprint of a large rack mounted server is order-of-magnitude a ton of carbon a year. Both are well documented and standardized, but most of the discussion occurs around attributional accounting. The first thing to understand is that doing things consumes time and energy and has a carbon footprint of its own.

Energy 52

Energy Cloud Traffic Transportation 52

Testsigma

FEBRUARY 3, 2021

Mobiles have different models, screen resolutions, operating systems, network types, hardware configurations, etc. Also, how to test the hardware of the mobile phone itself, is it supporting all the software as it should? Let us have a look at the most popular types of mobile testing for applications and hardware.

Mobile 82

Mobile Testing Hardware C++ 82

Dotcom-Montior

DECEMBER 8, 2021

Systems, web applications, servers, devices, etc., You cannot virtualize everything…yet. Software services still require physical devices and hardware for them to function. Like Slack, Microsoft is a real-time communication application that offers features like online messaging, video chat, and document sharing.

Social Media 90

Social Media Monitoring Latency DevOps 90

Smashing Magazine

SEPTEMBER 21, 2021

Finally, if you have some tasks to do on remote servers, you’ll often end up using the shell. It’s also simple to use, the documentation is great, and most importantly, you can manage your windows with your keyboard only (if you want to). It’s very similar to the virtual desktops many Linux desktop managers have. Vim in action.

Development 99

Development Energy Programming Efficiency 99

Smashing Magazine

JANUARY 11, 2021

You can download the spreadsheet as Google Sheets, Excel, OpenOffice document or CSV. In the end, it’s not the load events or server response times that define the experience, but the perception of how snappy the interface feels. It used to provide an insight into how quickly the server outputs any data. Large preview ).

Performance 145

Performance Cache Media Metrics 145

Percona

AUGUST 27, 2018

Essentially, you can assign a thread to a specific virtual CPU. MySQL 8 introduced a feature that is explained only in a single documentation page. It is well hidden in the Optimization: Optimizing the MySQL Server chapter. MySQL determines, at startup, how many virtual CPUs are available. Let us start with a disclaimer.

Tuning 45

Tuning Virtualization Testing Servers 45

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

Dynatrace

AUGUST 5, 2019

Lift & Shift is where you basically just move physical or virtual hosts to the cloud – essentially you just run your host on somebody else’s hardware. The following shows one of the slides I use to answer the question: What happens if I move this group of servers? Where to invest in data compression?

Cloud 31

Cloud Traffic Database Network 31

All Things Distributed

JANUARY 18, 2012

Behind the scenes, Amazon DynamoDB automatically spreads the data and traffic for a table over a sufficient number of servers to meet the request capacity specified by the customer. After the successful launch of the first Dynamo system, we documented our experiences in a paper so others could benefit from them.

Scalability 167

Scalability Database Ecommerce Latency 167

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.” A year after the first web servers became available, how many companies had websites or were experimenting with building them? Until AI reaches 100%, it’s still in the process of adoption.

Open Source 108

Open Source Artificial Intelligence Google Infrastructure 108