Infrastructure at your Service

DBA Archives - Page 4 of 5 - Blog dbi services

Open source Team

PostgreSQL : Qu’ai-je installé, Où sont mes données ?

By | Technology Survey | One Comment

Dans mon dernier article sur PostgreSQL, j’ai présenté l’installation du logiciel en explorant les 2 solutions suivantes, l’installation Debian et l’installation EntrepriseDB. Ces deux installations créent immédiatement un cluster de base de données, Debian nous imposant le point de stockage et EntrepriseDB nous proposant de saisir une destination. Je vous propose maintenant d’explorer ce qui a été installé sur votre disque à la mise en route de ce cluster de base et d’analyser les différences entre les deux installations.

Read More
Stéphane Haby

Stéph@TechEd 2012: Episode 1 – the Pre-Conf. Seminar

By | Technology Survey | No Comments

This morning, I was very happy to go to my first TechEd. Between the 10 seminars, as I said yesterday, I started with SQL Server 2008R2/2012 performance, tuning and optimization session. The thing is that we had just one session for the whole day. I will not copy the presentation of the 2 speakers (Thomas LaRock and Denny Cherry) who presented remarkably this session despite the failure of air conditioning during the morning. Fortunately, it…

Read More
Stéphane Haby

SQL Server 2012: Feature Pack

By | Database Administration & Monitoring | 2 Comments

Since the third CTP version of SQL Server 2012 codename Denali, you have some features available to provide an additional value for Microsoft® SQL Server 2012 like the other SQL Server versions. This Feature Pack or Manageability Tool Kit are available but are not the final version. I have compiled all information in this blog to find it easily.

All DBA should know that Feature Pack exists, how to find it and of course use it.Wink

Read More
Grégory Steulet

MySQL Data High Availability with semi-synchronous replication

By | Hardware & Storage | No Comments

Starting with MySQL 5.5 it is possible to configure semi-synchronous replication. As you probably know, by default, MySQL replication is asynchronous.  Asynchronous replication means that events/transactions applied on one server are not immediately applied on the other one. In the specific context of MySQL such behavior means that the MySQL Master writes transactions/events to the local binary logs, however it has no idea when the slave(s) will get and process them. Of course such configuration can lead, in case of failover, to some transaction loss since there is no guaranty that the transactions have been transmitted on the standby server(s).

Read More
Stéphane Haby

SQL Server 2012 ‘Denali’: a new panel of DMVs

By | Database management | One Comment

Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.
Since few months, I test the future new version SQL Server 2012 codename Denali and I was very surprised form the news DMVs from this version.
I will just explain some DMVs very interesting for a DBA.
My article is based on msdn web site reference and you find in the end from each chapter a msdn reference for more details of the DMV.

Read More
Stéphane Haby

SQL Server Tuning: Detect SPARSE columns candidate

By | Application integration & Middleware | 6 Comments

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 have seen.
This article present a script to find the potential columns that can have the sparse property with the usage restrictions to make a space tuning in your database and especially for Data Warehouse (DWH).

The database example that we used, is AdventureWorksDW2008R2.

Read More
Oracle Team

LOB : « enq : HW contention » 

By | Hardware & Storage | No Comments

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 à zéro pour refaire un modele relationnel en 3em forme normal (3NF), plus efficace et mieux conçu dans notre « RDBMS » favori, mais la réalité étant ce qu’elle est nous devons faire avec et au mieux.

De plus Oracle n’est pas qu’une base de données relationnelle :-) on l’oublie trop souvent.

Read More