Infrastructure at your Service

Tag

Storage Archives - Page 2 of 2 - Blog dbi services

Oracle Team

Oracle Database Appliance: new ODA X3-2 architecture

By | Operation systems | No Comments

A few weeks ago, I posted an article about Oracle Database Appliance, focusing on ODA version 2.5.0.0.0. However, a new update of ODA, version 2.5.5.0.0, was released by Oracle on 5 March. This posting will focus on the new ODA release, which leads to a new hardware architecture. So, what’s new with this new ODA version? According to the Release Notes, ODA now supports the new X3-2 architecture which allows additional hardware and storage capabilities. Physical…

Read More
Oracle Team

Bug on Oracle 11.2 “ORION FAILS WITH ORA-27061”: Patch available!

By | Application integration & Middleware | No Comments

In march 2011, my colleague Gregory Steulet published an article about Simulating and testing I/O performances with Orion. In this article, he wrote about a bug concerning Orion on Oracle 11.2, reported in Oracle bug number 9104898: “ORION FAILS WITH ORA-27061: WAITING FOR ASYNC I/OS FAILED”. Trying to compare performances of storage devices on a virtual machine between a classical and a paravirtual storage adapter, I experienced the same error when using large IOs. I…

Read More
Stéphane Haby

SnapManager for SQL Server: databases limitation policy

By | Database management | No Comments

I recently talked to a customer about SnapManager, its recommendation on the number of databases and about a way to prevent the creation of more than 35 databases. The NetApp recommendation is no more than 35 databases on a single volume. The reason is that SQL Server has to use 4-5 worker threads per database in order to manage the freezing and un-freezing I/O for each database. Look at this note: More information on this…

Read More
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Ă©[email protected] 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
David Hueber

OpenWorld 2011 is over … Having a last glance on ASM & disk failures

By | Technology Survey | No Comments

So we are now arrived at the end of the largest Oracle OpenWorld ever. Around 45’000 people had joined San Francisco to exchange around IT and especially Oracle technologies.
It has been a great conference with much of interesting sessions and as each year several announcements: Enterprise Manager 12c, Exalytics and Oracle Public Cloud.

For my last post about OOW11, I want to talk about the last session I attended. Who said that the late sessions are usually having less interest? I personally was lucky enough to attend a great presentation held by Oak Table member, Alex Gorbachev. Alex used ASM to demonstrate how hardware and software fault tolerance mechanisms, especially mirroring, are affected by different parameters such MTBF.

Read More