Performance

Plotting SQL Server Performance counters with Python

As a consultant, I often use Performance Monitor (Perfmon) to collect performance metrics for SQL Server. After running Perfmon for, say, a week to capture a baseline of server activity, you can end up with a(…)

New Features 23c, Overview (in extracts):

In this blog I want to introduce some of the new features of the Oracle 23c developer edition. It will be only a selection of some of the main features. It is not the intention to give you a thorough(…)

SQL Server: Is this ad hoc workload an issue?

I ran into an interesting scenario with a customer that I want to share in this blog post.This customer is running a data-loading activity on a monthly basis from his business application.He did not complain about the performance, the time(…)

OctoPerf Dynamic Browsing

I want to improve the Virtual User (VU) I created in my previous blog by adding dynamic browsing of the shop web site. Indeed, as VU is based on a HAR file, it is statically browsing(…)

OctoPerf Load Testing

OctoPerf is a SaaS tool based on Apache JMeter, the load test functional behavior and measure performance reference tool. Among others, it has several advantages compared to JMeter: It can integrate with(…)

Apache JMeter Playground

As I am training myself to Apache JMeter, beside testing on my Oracle environment (which include Oracle Internet Directory, Oracle Directory Service Manager, Oracle Identity and Access Management, a Database and a web application protected by(…)

SQL Server: Automatic Soft-NUMA and uneven CPU load

SQL Server has CPU limitations depending on the Edition. If your VM is not configured properly you can reach these limits very easily. In a previous post, I described the effect VM misconfigurations can have on performance because not(…)

SQLBits 2022 – Levelling up my Performance Tuning skills

As a consultant at dbi services, I am lucky enough to have time dedicated to training and conferences. This week I have the chance to attend one of the most important conferences for Data professionals: SQLBits 2022.

How to configure Linux Server to run Oracle Database 19c on Persistent Memory

Introduction to Persistent Memory In the last few years, storage media have become more and more advanced and faster. Today, SSD disks are almost standard as storage and if an Oracle database really has an I/O critical workload, nvme storage(…)

Statspack with Oracle Database 19c and Multitenant

Introduction When it comes to performance analysis on Oracle databases, everybody think about Diagnostic Pack. This is a very complete tool and it brings much more metrics than a DBA can analyze. But there is a big drawback with this(…)