Database Administration & Monitoring

Getting started with Ansible – Creating the PostgreSQL instance

In the last three posts we did the initial Ansible setup, installed the operating system packages, created the PostgreSQL group and user and downloaded, compiled and installed the PostgreSQL binaries from(…)

Getting started with Ansible – Download the PostgreSQL sources, compile and install

In the last post in this series we looked at how you can instruct Ansible to install packages on the operating system using the yum module and how you can create(…)

Getting started with Ansible – Installing OS packages, creating groups and users

It has been quite a while since the first post in this series: "Getting started with Ansible - Preparations". If you recap from the initial post Ansible was running on the control host and this simple Ansible(…)

Redo log block size on ODA X6 all flash

By Franck Pachot . On the Oracle Database Appliance, the redo logs are on Flash storage (and with X6 everything is on Flash storage) so you may wonder if we can benefit from 4k redo blocksize. Here are some tests(…)

ODA X-6 log file sync with NVMe flash

By Franck Pachot . The new ODA X-6 has been announced last month with two smaller configurations and smaller prices: 2S and 2M. Small, but high performance configuration: all SSD, and I/O transfer optimized for Flash with PCIe bus and(…)

Getting Ansible up and running on a SLES 12 SP1 host

Recently at a customer we had to setup Ansible on a SLES 12 SP1 host. In comparison to RedHat or Ubuntu based distributions there are some more steps to do as Ansible is not(…)

SQL Server AlwaysOn: new services packs and new diagnostic capabilities

As you certainly know, the SQL Server 2014 SP2 has been released by Microsoft with some interesting improvements that concern SQL Server AlwaysOn and availability groups feature.

AMM and ASMM derived parameters

By Franck Pachot . The latest DBA Essentials Workshop training I've given raised a question about PGA_AGGREGATE_LIMIT. The default depends on PGA_AGGREGATE_TARGET. So how is it calculated in AMM where PGA_AGGREGATE_TARGET is dynamic? Is it also(…)

SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog

With the latest release of SQL Server Management Studio(SSMS) 2016 (13.0.15500.91), downloadable here, was introduced new CMDLETs for Always Encrypted, SQL Agent and the  ErrorLog. In this article, I will(…)

Oracle Public Cloud patch conflict

By Franck Pachot . This morning I wanted to test a patch (18633374) in the Oracle Cloud Service. The DBaaS was created as an 'Enterprise Edition Extreme Performance' which comes with all options, including multitenant option. I applied my patch.