Infrastructure at your Service

Category Archives: Hardware & Storage

David Barbarin

SQL Server 2016 : availability groups and automatic failover enhancements

By | Hardware & Storage | 3 Comments

Let’s continue with this study of the new availability group enhancements. Others studies are available here: New database issue level detection for automatic failover Potential features in standard edition This time we’ll talk about the possibility to enrol a third replica for automatic failover. It implies of course to configure synchronous replication between the 2 pairs of replicas and this is at the cost of degrading the overall performance. But it seems that in this…

Read More
David Barbarin

SQL Server 2016 : availability groups and the new potential support for standard edition

By | Hardware & Storage | No Comments

In my first blog about availability groups with SQL Server 2016, I talked quickly about the new interesting option: DB_FAILOVER. In this blog post, I will continue by introducing the new potential support of availability groups in a standard edition (based on the last Microsoft Ignit news). Yes, this sounds a great news because it will increase the scope of possible customers but bear in mind that it concerns potentially the standard edition (not in…

Read More
David Barbarin

SQL Server 2016: availability groups and the new option DB_FAILOVER

By | Hardware & Storage | 2 Comments

Let’s continue the SQL Server 2016’s discovery with one of my favourite topic: the AlwaysOn availability groups (AAGs). There are some improvements on this area. First of all, let’s introduce one of them (DB_FAILOVER option) by remembering of the availability groups behaviour with the previous versions of SQL Server. One misconception that exists at different customer places is that an availability group doesn’t detect a database failure. No, this not a joke but the pure…

Read More
Stéphane Savorgnano

In-Memory OLTP: Hash and Range indexes

By | Hardware & Storage | No Comments

Since SQL Server 2014 CTP2, Microsoft has introduced a new kind of index which is the Range index. We have now two ways for indexing an In-Memory table: using either an Hash index or a Range index. These two indexes are slightly different. In fact, a Hash index is a set of buckets, 8-bytes memory pointers, which points to the actual row data or row chain data. SQL Server 2014 uses a hash function to…

Read More
Daniel Westermann

getting started with postgres plus advanced server (3) – setting up a hot standby server

By | Hardware & Storage | 5 Comments

So, we have a ppas 94 database up and running and we have a backup server for backing up and restoring the database. Now it is time to additionally protect the database by setting up a hot standby database. This database could even be used to offload reporting functionality from the primary database as the standby database will be open in read only mode. Again, I’ll use another system for that so that the system…

Read More
Oracle Team

Yesterday’s AWR Straight to the Goal

By | Hardware & Storage, Oracle | 6 Comments

By Franck Pachot . Yesterday I was a speaker at Collaborate15 and did my presentation about reading an AWR report. That was great. Many people (and not enough seats). Here are some aswers about questions that came later. I did that presentation at DOAG last year in a much bigger room. But because of the bigger room there was no questions, and because of the tension I felt in that big room, I made it…

Read More
David Barbarin

Weird issue with sys.fn_hadr_backup_is_preferred_replica() function

By | Hardware & Storage | No Comments

A couple of days ago, I faced a weird backup issue with SQL Server AlwaysOn and availability groups at one of my customer (thank to him to point out this issue ). After installing our DMK tool (Database Management Kit) about database maintenance for AlwaysOn, my customer noticed that their databases have not backed up. Ouch … what’s going on? I never ran into this issue before… Do the problem comes from our tool? In…

Read More
David Barbarin

Vsphere 6.0 improvements for Windows Failover Clusters

By | Hardware & Storage | No Comments

A couple of days ago, VMWare announced vSphere 6.0. I guess many of our customers have been waiting for this new release and probably I will see in the next few months this new version rolled out on the top of their virtual SQL Server vitual machines. If you missed this event, you can still register here. I’m not a VMWare expert but VSphere 6.0 seems to be a storage-oriented version with a lot of improvements…

Read More
Grégory Steulet

All you need to know about Oracle Database licensing with VMware

By | Hardware & Storage | 79 Comments

You are running Oracle on VMware and are not 100% sure that you are compliant with the Oracle licensing rules? This article is for you! As I have been confronted several times with Oracle License reviews with VMware installations, I decided to write this article in order to provide answers to the most frequent questions I have received from customers. Introduction Licensing is not an easy topic to address and this difficulty is not specific…

Read More
David Barbarin

WSFC : Manual or automatic failover? That is the question!

By | Hardware & Storage | 2 Comments

During the night, you receive an alert concerning your SQL Server failover cluster or your availability groups and you’re in panic mode because the message displayed is : a failover has occured .. see the log for more details … So keep quiet and after connecting to your environment you are not able to find anything … What was happen? Maybe someone has triggered manually a failover and you are not aware of it. I’m…

Read More