Infrastructure at your Service

Category

Database Administration & Monitoring

Mouhamadou Diaw

SharePlex Compare and Repair commands

By | Database Administration & Monitoring | 2 Comments

Reading Franck Pachot blog about comparing source and target in a Dbvisit replication (http://blog.dbi-services.com/compare-source-and-target-in-a-dbvisit-replication/), I decide to write a small article about how we can do same thing with SharePlex. Indeed SharePlex provides built-in commands to compare and repair synchronization. Below is our configuration file. We are just replicating table article to article_rep. Both tables contain 2000000 rows datasource:o.SPLEXDB #source tables target tables routing map titi.article titi.article_rep [email protected] From the source let’s insert 2 rows…

Read More
Franck Pachot

Oracle Multitenant feature name

By | Database Administration & Monitoring | No Comments

By Franck Pachot . We all know what is the multitenant option: a container database (CDB) with multiple user pluggable databases (PDB). This requires Enterprise Edition plus option. But you can use the same architecture without the option and even in Standard Edition: a CDB with only one user PDB. It is called “single-tenant” or “lone PDB”. How do you call this new 12c architecture?

Read More
Microsoft Team

SQL Server 2016 AlwaysOn: Direct seeding and performance considerations

By | Database Administration & Monitoring, Development & Performance | No Comments

This blog post follows the previous one about new direct seeding feature shipped with SQL Server 2016. As a reminder, I had some doubts about using direct seeding with large databases because log stream is not compressed by default but I forgot the performance improvements described into the Microsoft BOL. I also remembered to talk about it a couple of months ago in this blog post. So let’s try to combine all the things with the…

Read More
Franck Pachot

Script to suggest FK indexes

By | Database Administration & Monitoring | 3 Comments

By Franck Pachot . In Oracle, when the referenced key is deleted (by delete on parent table, or update on the referenced columns) the child tables(s) are locked to prevent any concurrent insert that may reference the old key. This lock is a big issue on OLTP applications because it’s a TM Share lock, usually reserved for DDL only, and blocking any modification on the child table and blocking some modifications on tables that have…

Read More
Microsoft Team

SQL Saturday 510 – Locks, latches et spinlocks – Les slides

By | Database Administration & Monitoring | No Comments

Cette annĂ©e les gens ont encore rĂ©pondu prĂ©sent au SQLSaturday Ă  Paris qui devenu incontournable pour ceux qui aiment Ă©changer autour de la donnĂ©e avec les produits Microsoft. Par ailleurs, le temps a plutĂ´t Ă©tĂ© au rendez-vous cette annĂ©e et la vue depuis le 40ème Ă©tage de la tour Montparnasse est toujours aussi impressionnante. Pour ma part, j’ai eu le plaisir d’animer une session en fin de journĂ©e sur la concurrence d’accès mais vu depuis SQL Server avec 3…

Read More
Oracle Team

GoldenGate 12.2 – Installation of the monitoring agent

By | Database Administration & Monitoring | No Comments

As described in my last post, GoldenGate Studio requires the monitor agent on each GoldenGate instance. The goal of this agent is to allow GoldenGate Studio to interact with GoldenGate, for example, to deploy a new solution. So lets start with the installation of the agent. Download The first step is to download the monitor agent (Oracle GoldenGate Monitor). It is available here. Installation The second step is to install the product. After you have…

Read More
Stéphane Savorgnano

SQL Server 2016: Always Encrypted – part 2

By | Database Administration & Monitoring, Technology Survey | No Comments

In my last blog post about SQL Server 2016 Always Encrypted, here, I showed how to use this new functionality but also that you have to separate the different execution context with an Application server, a database server and a security server to avoid that certificate will be available for all users and break the segregation. Let’s see how to build those environment. In my security server named SQL2016-2, I first create a Self-signed certificate…

Read More
Daniel Westermann

PostgreSQL as a central reporting hub? – Yes, of course

By | Database Administration & Monitoring | No Comments

For every client we do projects for there usually are database systems from various vendors. In most places you at least find some Oracle and MS SQL Server databases. Probably somewhere there are even some MySQL/MariaDB or PostgreSQL instance running. The Oracle and MS SQL Server stuff almost always is there because vendors require it. For MySQL/MariaDB the common use case are web applications, ticketing systems and home grown developments. At some point in time…

Read More
Franck Pachot

Statspack Idle Events

By | Database Administration & Monitoring | 5 Comments

By Franck Pachot . When you don’t have Enterprise Edition + Diagnostic Pack, you cannot use AWR but you can, and should, install Statspack. Statspack is still there, but unfortunately do not evolve a lot. The most important section, the ‘Top 5 Timed Events’ shows only foreground events, or is supposed to do so. When a user process waits on a background process, this section must count only the foreground wait and not the activity…

Read More