All articles

SQL Server 2012 ‘Denali’ : AlwaysOn High Availability – Restore is blocked

During our test to create a failover clustering with the new function 'AlwaysOn High Availability', we had a few difficulties to overcome like the restoring of databases of the secondary cluster node. In this article, we will just explain you(…)

Windows Server 8 Hyper-V 3.0: a real step forward in virtualization

As we are on Microsoft Connection Days 2011 in Lausanne yesterday, we have a presentation of Windows Server 8 and specifically of Hyper-V 3.0.I take this opportunity to introduce some news about this.

SQL Server Tuning: Detect SPARSE columns candidate

dbi services search and test all tools or functions possible to optimize or to win something to propose the best tuning possible in their client.The property of Spare columns is not the most used in client environment that we(…)

Database space management issue with Grid Control 11g

My colleague Hervé Schweitzer reported a very interesting issue to me. It is about the usage of Grid Control 11g while monitoring the available space on an Oracle database – in our case a 10.2.0.3 target database. This post continues(…)

Changing the reference instance for SQL Server Integration Service (SSIS)

In my experience, I have seen many clients do not know how to do when they have multiple databases instances and Integration Servicet for manage the end of the instance that is the reference for Integration Services. When(…)

Compression advisor: excessive redo log file generation

Last week by a customer, we experienced an excessive redo log generation filling up rapidly the FRA (Flash/Fast Recovery Area) with archivelog files which caused the database to crash.

Take care while upgrading your Oracle DB with “DBUA”

Last Week at my Customer, I used dbua to upgrade an oracle database 10h to 11g, the migration run successfully. But next day I had a monitoring message that the diag directory is groing very fast.

LOB : « enq : HW contention » 

Aprés le post sur « Utilisons les securefile », revenons sur le sujet LOB avec une approche performance, stockage.  Nous rencontrons parfois des modèles de données étranges, nous aurions envies en tant que DBA de tout reprendre à(…)

Oracle space management & recycle bin

This post describes some basic Oracle database management issues database administrators might be confronted with. It is about space management and differences observed while monitoring the available space from several point of views (tablespace/datafile) in Grid Control 11g. It also(…)

Diving into Databases

By dbi services, we are a few poeples passionate by diving.We take this opportunity to let you dive into the two databases lakes Oracle and SQL server and see their similarities and differences. For this first level of diving(…)