Published: (Updated: ) by . Leave a Comment on Notes on tuning postgres for cpu and memory benchmarking.
Recently I wanted to measure the impact of NUMA placement and Hugepages on the performance of postgres running in a VM on a Nutanix node. To do this I needed to drive postgres to do real transactions but have very little jitter/noise from the filesystem and storage. After reading a lot of blogs I came […]
Published: (Updated: ) by . Leave a Comment on Generate load on Microsoft SQLserver Windows from HammerDB on Linux.
Often it’s nice to be able to drive Windows applications and databases from Linux, especially if you are more comfortable in a Unix environment. This post will show you how to drive a Microsoft SQL Server database running on a Windows server from a remote Linux machine. In this example I am using Ubuntu 22.04, […]
Published: (Updated: ) by . Leave a Comment on How to drop tables for HammerDB TPC-C on SQL Server.
From the SQL Window of SQL*Server. Issue these commands to drop the tables and procedures created by HammerDB. This will allow you (for instance) to re-create the database, or create a new database with more warehouses (larger size) while retaining the same name/DB layout.
Published: (Updated: ) by . 3 Comments on SuperScalin’: How I learned to stop worrying and love SQL Server on Nutanix..
TL;DR It’s pretty easy to get 1M SQL TPM running a TPC-C like workload on a single Nutanix node. Use 1 vDisk for Log files, and 6 vDisks for data files. SQL Server needs enough CPU and RAM to drive it. I used 16 vCPU’s and 64G of RAM. Running database servers on Nutanix is an […]
