Infrastructure at your Service

Category Archives: Hardware & Storage

David Hueber

ODA – 32GB template but got a database with 16GB SGA???

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

I got an interesting question today from a customer which created a database on ODA. He selected the template odb-04 which shows 32GB Memory but got a database with a 16GB SGA… Is it due to the PGA size, a limitation in the system, the huge pages usage which is reached or even a bug?  

 
Read More
Nathan Courtine

Manage Azure in PowerShell (RM)

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

Azure offers two deployment models for cloud components: Resource Manager (RM) and Classic deployment model. Newer and more easier to manage, Microsoft recommends to use the Resource Manager. Even if these two models can exist at the same time in Azure, they are different and managed differently: in PowerShell cmdlets are specific to RM. In order to be able to communicate with Azure from On-Premises in PowerShell, you need to download and install the Azure…

 
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
Pierre Ochsenbein

Shrinking Oracle VM VirtualBox with Zerofree

By | Hardware & Storage, Operation systems | No Comments

In this blog I would like to talk about Shrinking a Virtual Machine with Oracle databases and MySQL which is install. Unfortunately, whilst Virtual Box will dynamically expand the hard drive as it’s required, it won’t dynamically shrink it again if you free up space in the VM. The good news is You can shrink a dynamic Virtual Box disk image and so reduce the size of your VM infrastructure. I have use the Zerofree…

 
Read More
David Barbarin

Windows Server 2016: Introducing Storage Spaces Direct

By | Hardware & Storage, Operation systems | No Comments

Have you heard about Storage Spaces introduced by Windows Server 2012? Well, this is a very interesting storage feature that allows us to deal with functionalities like storage virtualization, RAID capabilities, thin or thick provisioning, cluster shared volume (CSV), efficiently file repair and so on. In addition, the Windows 2012 R2 version has also introduced some enhancements like storage tiering, write-back caching, datadeduplication, parity space support for failover clusters, JBOD enclosure awareness… A bunch of…

 
Read More
David Barbarin

Windows Server 2016: Introducing stretch cluster functionality

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

Let’s continue with the new high available functionality shipped with the next Windows version. In my previous blog, I talked about the new site awareness feature that provides more flexibility to configure failover resources priorities and more granular heartbeat threshold as well by introducing the new site concept. This time, we’ll talk about stretch cluster. What’s that? Let’s introduce the concept with some customer experiences for which we introduced high availability with the implementation of…

 
Read More
David Barbarin

SQL Server 2016 : availability groups and performance improvements

By | Development & Performance, Hardware & Storage | No Comments

During the last SQL Saturday in Paris, I had the opportunity to co-present the new SQL Server 2016 features and one of my topic concerned the availability group’s enhancements. I mentioned the replication throughput improvement but without giving more details and this is the idea of this blog post. First of all, let’s remind that the network throughput is part of the synchronous replication process and it is directly tied to the application transaction performance….

 
Read More
David Hueber

ODA – VMs possibilities & performances

By | Hardware & Storage | No Comments

As you know it is possible to install the ODA in a virtualized mode and to take avantages from all cores not licensed with Enterprise Edition for additional VMs. The question is what could we do with it and which performances could we expect… The answer to the first question is indeed pretty simple….almost everything. If you have and ODA X5-2 with the version 12.1.2.3.0 implemented in virtualized mode then you are running an OVM…

 
Read More
David Barbarin

SQL Server 2016 : availability groups and the new SSISDB support

By | Hardware & Storage | 2 Comments

This blog post is focused on the new supportability of SSIDB catalog on AlwaysOn architecture. Others studies are available here: New database issue level detection for automatic failover Potential features in standard edition Automatic failover enhancements New load balancing features with read-only replicas New clustered columnstore index support A couple of weeks ago, I was involved in an SSIS infrastructure project with SQL Server 2014. As you know, the SSIS architecture has fundamentally changed since…

 
Read More
David Barbarin

SQL Server 2016 : availability groups and the new clustered columnstore index support

By | Hardware & Storage | No Comments

This blog post is focused on the new supportability of clustered columnstore index on the high- availability read-only replicas. Others studies are available here: New database issue level detection for automatic failover Potential features in standard edition Automatic failover enhancements New load balancing features with read-only replicas After reading some improvements from the columnstore index feature side, I was very surprised to see the following section:   Clustered columnstore indexes are now supported on AlwaysOn…

 
Read More