Hardware & Storage

When tempdb write latency points below SQL Server

During a recent performance review on a SQL Server 2019 instance (AlwaysOn Failover Cluster Instance, bare-metal), one number stood out. This post follows the investigation: from a latency figure in a DMV, down the I/O path to a(…)

Wait stats and Sub-NUMA clustering 

During a healthcheck at a client’s site, we collected performance data from a SQL Server 2019 Enterprise instance hosting a BI / data warehouse workload. Two lines in the wait statistics report immediately caught the eye: hundreds of hours(…)

SQL Server Snapshot Backup and Restore with Proxmox ZFS (1/4)

We are currently working with clients on migrations to SQL Server 2022 and SQL Server 2025. During a discussion with one client, we reviewed some of the benefits introduced in the latest SQL Server 2022 and 2025 releases.

ExaCC OCI integration with OEM 13.5 Cloud Control installed On-premises.

Introduction I wrote this article to show how you can integrate Legacy OEM with your Cloud environment in this case Oracle ExaCC.To have overall view on your Exadata X9M Cloud Infrastructure, statistics related to CPU/Memory/ASM Storage usage. Your on(…)

Why you should consider keeping your ODA more than 5 years

ODA is a long-lifetime platform!(…)

ODA version 19.17 is available: how to patch?

How to patch your ODA to 19.17(…)

Warning: ODA HA disk enclosure is not smart!

Introduction Apart from the number of servers (1 vs 2), the main difference between Oracle Database Appliance lite (S/L) and High-Availability (HA) is the data disks location. They are inside the server on lite ODAs, and in a dedicated(…)

When unreachable NFS share mess up your Dbvisit Standby configuration

If I had to rank my favorite Oracle-related tools and software, Dbvisit Standby would likely be at the top of the list. You are reading this post, so you probably know that Dbvisit Standby is a(…)

ODA update-server to 19.12 fails on Patch GI with RHP

Sometimes giving a workshop is a good opportunities to test new things...this what happened to me today...  :-) While giving an ODA workshop, I thought it was a good opportunity to test patching to the new 19.12 release. However during(…)

Exadata X9M release

I would like to share some personal thoughts. September 28th 2021, Oracle released the eleventh Exadata data machine called "X9M-2" (2 CPU sockets), X9M-8 (8 sockets) and ZDLRA X9M. Exadata is a computing platform to run Oracle RDBMS, zero data(…)