Database Administration & Monitoring

CPU_COUNT

When you have less CPU threads than the number of processes that has something to run in CPU, the OS will schedule them to share the CPU resource. Increasing the workload at that point will not increase the throughput because(…)

Large Pages on Windows

By Franck Pachot .

Discovering SharePlex for Oracle

By Mouhamadou Diaw Nowadays, replicating data is very important. Many tools exist in the market (Goldengate, Dbvisit …). In this article we talk about a Dell Product tool that can be used for data replication: SharePlex. The goal is to(…)

SQL Server 2016: RTM first installation

I was very surprise with this new version of SQL Server and his installation. The first point is that we don’t need any more to install the framework .Net 3.51 manually… The second main point is the configuration of TempDB(…)

SQL Server AlwaysOn: is my database ready for failover?

In this blog post I just want to clarify values that we may find from the is_failover_ready column of the sys.dm_hadr_database_replica_cluster_states DMV. A couple of days ago, I had an interesting discussion with one of my customers during which he(…)

Instance Caging and multitenant: do the right setting

When you want to do instance caging, you have to set manually CPU_COUNT and to set a resource manager plan. If you By Franck Pachot . only the CPU_COUNT no instance caging will occur. Except during the maintenance window where(…)

Oracle on Windows Server Core

By Franck Pachot . If SQL Server, the database for GUI fans, goes to Linux then Oracle, the database for command line fans, can go to Windows. Ok, that's not new. But I'm not talking about the Windows with media(…)

EM13c and postgres plugin

As an Oracle DBA I use Enterprise Manager to monitor Oracle databases at my client’s sites. I also administer more and more Postgres databases. I decided to download the Blue Medora plugin in order to monitor the postgresql databases with(…)

Which parameter changes do require a restart of my PostgreSQL instance?

Starting wiht PostgreSQL 9.4 you can change parameters in postgresql.conf with the "alter system" command in psql. In principle every parameter can be changed that way but not every parameter is applied immediately. Some of(…)

SCOM: schedule group maintenance task with PowerShell

In my last blog post, here, I spoke about how to place SCOM group in maintenance mode. This script is really interesting with an integration in Windows Task Scheduler. At the end, the main purpose is to plan a(…)