Infrastructure at your Service


Database Administration & Monitoring

Franck Pachot

ODA X6 command line and Web Console

By | Database Administration & Monitoring | No Comments

By Franck Pachot . The ODA X6 comes with a new command line (odacli) which replaces oakcli, and with a small web console which can display information about the appliance, the databases and the provisioning jobs. It also has the possibility to create a database, but this is for next blog post. In this post I’ll show which information are displayed once the ODA is installed.

Read More
Stéphane Haby

Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE

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

Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: CLONEDATABASE. „DBCC CLONEDATABASE sollte Kopien eines Schemas und den Statistiken einer Produktionsdatenbank erstellen, um bei Leistungsproblemen Abfragen zu untersuchen.“ MSDN Quelle finden wir hier. Dieser Befehl kann nur Benutzedatenbanken klonen. Wie Sie sehen, fĂĽr die Systemdatenbanken ist es nicht möglich, denn es treten Fehlermeldungen auf: Msg 12603, Level 16, State 1, Line…

Read More
Nathan Courtine

Generate Azure VM with Resource Manager deployment in PowerShell

By | Database Administration & Monitoring, Hardware & Storage, Operation systems | No Comments

Recently, there is a new way to manage the Azure infrastructure with Resource Manager. It brings many advantages regarding the classic deployment. The differences between these two deployments will not be covered in this blog because it is not the initial goal, and it already exists a very good Microsoft topic on this subject. In this blog, we will generate a new Windows Azure Virtual Machine using Resource Manager deployment with PowerShell from On-Premise. Remember,…

Read More

Windows: Sauvegarde RMAN sur un disque partagé

By | Database Administration & Monitoring | No Comments

Dans ce blog, je vais vous expliquer comment exporter les backups RMAN sur un « share disk » appartenant Ă  un Domaine. Assurer la sĂ©curitĂ© des donnĂ©es est l’une des tâches principales de l’administrateur : La mise en Ĺ“uvre d’une protection des fichiers sensibles de la base : Fichier de contrĂ´le Fichiers de journalisation La mise en place d’une stratĂ©gie de sauvegarde/rĂ©cupĂ©ration : AdaptĂ©e aux contraintes de l’entreprise TestĂ©e et documentĂ©e. Afin de vous documenter sur les diffĂ©rentes techniques de sauvegarde…

Read More
Oracle Team

How to do a Filesystem Resize (ext3/ext4) on Redhat running on VMware

By | Database Administration & Monitoring, Operation systems | No Comments

By William Sescu A filesystem resize can be done in several ways, online, offline, with LVM2 or without LVM2.  However, this blog will describe how to do an online resize of ext3/ext4 filesystems where a virtual disk (vmdk) is online added to a VMware Redhat guest OS. So let’s start with the online filesystem resize of ext3/4 filesystems on the Redhat guest OS.  A new virutal disk (preferably an eagerd zero thick on VM running…

Read More
Microsoft Team

SQL Server AlwaysOn: troubleshooting improvements with new service packs

By | Database Administration & Monitoring | No Comments

As promised in my latest blog, I will talk about improvements in the detection of the availability group replication latency. As a reminder, replication latency between high available replicas may be monitored in different manners so far. Firstly, in my experience I had the opportunity to use different performance counters as “Database Replica:Transaction Delay” and “Databas Replica:Mirrored Write Transactions/sec” in order to get a good picture of the latency over the time after implementing an…

Read More