All articles

ASM iostats

By Franck Pachot . A few screenshots and a link here. Sysadmins do not like ASM because they don't have the tools they like to manage the disks. For example, they don't want to run SQL queries to check performance,(…)

SQL Server 2016 AlwaysOn: distributed availability groups

This time, I will talk about distributed availability groups. What’s that? In short, a group of availability groups. Sounds good right? But in which cases may we need such architecture? Firstly, let’s say that(…)

SQL Server 2016 AlwaysOn: Add DBs in AGs with direct seeding

In this blog I would like to talk about two new features shipped with SQL Server 2016 for AlwaysOn availability groups. The first one concerns the new direct seeding capability and the seconde one introduces distributed availability groups(…)

12c online datafile move and resize

By Franck Pachot . I've described in previous posts how the 12c online datafile move works: your session process do the copy and tells other writers (dbwr and direct-path inserts) to write blocks to both files (old one and new(…)

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(…)

Attunity Replicate: additional column on the target

In December 2015, my colleague Vincent did a test with additional column with Oracle GoldenGate 12.2. Hervé & Vincent asked me(…)