Remove 2003 Remove Monitoring Remove Scalability Remove Servers
article thumbnail

What Adrian Did Next?—?Part 2?—?Sun Microsystems

Adrian Cockcroft

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. This was followed by a greatly expanded second edition with some additional chapters by Rich Pettit.

Tuning 52
article thumbnail

HammerDB MySQL and MariaDB Best Practice for Performance and Scalability

HammerDB

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. monitoring. Download and install HammerDB on a test client system, Like PostgreSQL another 2 socket server is ideal.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

HammerDB: Using MySQL 5.7 vs 8.0 to understand performance profiles

HammerDB

One of the most important concepts in analysing database performance is that of understanding scalability. Plotting these data points enables us to understand the scalability of the database software being tested on that system. software running on the same server. In this example, we will compare MySQL 5.7.33 and MySQL 8.0.25

article thumbnail

HammerDB Best Practice for PostgreSQL Performance and Scalability

HammerDB

As the name indicates the turbostat tool can be used to monitor the CPU turbo frequencies. . Also change the pg_hba.conf and add the ip addresses for your test server and load testing client running HammerDB. Download and install HammerDB on a test client system, another 2 socket server is ideal. cpu1: EPB 0. vm.swappiness = 0.

article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

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
article thumbnail

Why Tcl is 700% faster than Python for database benchmarking

HammerDB

To do this, we are going to rewrite HammerDB in Python and run a series of tests on a 2 socket Intel(R) Xeon(R) Platinum 8280L server to see how and why Tcl is 700% faster than Python for database benchmarking*. Background and Concepts. usr/local/bin/tclsh8.6 hammerdbcli auto pgtime.tcl HammerDB CLI v4.4

article thumbnail

HammerDB Concepts and Architecture

HammerDB

This article Threads Done Right… With Tcl gives an excellent overview of these capabilities and it should be clear that to build a scalable benchmarking tool this thread performance and scalability is key. MS SQL Server/Linux and Windows. You can download and compile TCL/TK 8.6 HammerDB CLI v3.1 Oracle /TimesTen.