Infrastructure at your Service
After more than 2 years of experience in Kubernetes cluster administration, I am deeply convinced that one of the most important things to have as an ops guy is a sandbox cluster at your disposal. This can be either a sleeping cluster or a new fresh installation with all your standards replicated on it to perform your series of tests. In this blog post, we consider that you have an AWS account with limited credits,…
One of the features which is currently missing in PostgreSQL is Temporal Tables. Other database systems have that since a long time and many people want to have in PostgreSQL as well. If you don’t know what it is, here is a short overview. Basically you can ask for a row as it was at a specific point in time. The patch which implements this, is currently in status “Ready for Committer”, which does not…
When parallel execution was introduced with PostgreSQL 9.6 it was quite limited and supported only a few operations to run in parallel. Over time more and more operations were enabled to run in parallel. When PostgreSQL 15 will be released next year it will come with parallel distinct. Here is an easy example:
Quite some time ago I’ve written about relation files in PostgreSQL and when they get created. In that post we talked about the files containing the actual data, the free space map (fsm) and the visibility map (vm). But this is not all, there is another kind of file you might spot if you take a look into the directory of a database.
For a customer, I do some research to find which TLS is used on the SQL Server environment. The only way is to create an Extended Event. A big limitation is that the event used is only available on SQL Server 2016 and +. Before use the Built-In Diagnostics (BID) traces. After I implanted the first TLS Monitoring on a SQL Server 2016 with the query: CREATE EVENT SESSION [TLS_monitoring] ON SERVER ADD EVENT…
Few days ago, after a reboot, we had this warning on the Agent Error Logs on many servers: Warning [396] An idle CPU condition has not been defined – OnIdle job schedules will have no effect “The CPU idle definition influences how Microsoft SQL Server Agent responds to events. For example, suppose that you define the CPU idle condition as when the average CPU usage falls below 10 percent and remains at this level for…
Since Oracle 21c it is possible to convert the non CDB database into a PDB directly during the upgrade using the Oracle Autoupgrade Tool. This is an important enhancement, because with Oracle 21c the non CDB architecture is desupported, which means that with an upgrade to 21c a conversion is mandatory. Let’s test if this new feature really works and what needs to be considered. Work done by autoupgrade utility Check and Prepare Source non…
In the previous blog (Part 2) we have created a VM template for oracle database and we could successfully registered it in Nutanix Era. Now we are going to use it to provision an oracle database named ORATEST on a new VM called test1-VM. For more information on Nutanix products, I would encourage you to visit Nutanix website.
This is the part 2 of Nutanix Era blogs related to the use with Oracle databases. Before using Nutanix Era with Oracle and be able to provision oracle databases, we need to create a template VM. To do so, we will need to use prism. This template VM will only be used as a reference each time we will provision a database mainly to get the operation system and the Oracle environment. The cpu cores…
I’m currently setting up a lab for Nutanix Era in order to be able to provide some presentation on this subject and see how Nutanix Era interacts with Oracle databases. I therefore thought it would be certainly helpful and a good opportunity to share the feedback I’m getting from this experience. The lab has been built using Nutanix Cluster free trial integrated with our AWS Cloud account. This fist blog intends to provide only a…
Few days ago, I have very poor performance on a database that I migrate from SQL 2012 to SQL 2019. The developer Team asks me to upgrade the number of CPU and the Memory to have better performance. First, I ask the Team to give me some queries sample to test the performance between the old environment in SQL server 2012 and the new one in SQL server 2019. To do the test, I use…
Introduction Patching an Oracle Database Appliance is sometimes quite tough and you often struggle to solve failures at different steps. Regarding ILOM and BIOS patching errors, a simple workaround is possible. Errors when patching ILOM and/or BIOS This is something I recently had on an ODA X7-2S when trying to apply patch 19.11. Patching of the test server was OK, but patching the production server on a week-end was not OK. I needed to find…
