Infrastructure at your Service

Category

Operation systems

Oracle Team

RAC Attack! was another great success at C15LV

By | Operation systems, Oracle | No Comments

By Franck Pachot . The RAC Attack  – install a RAC in your own laptop – is a great success at Las Vegas. The idea is to help people follow the RAC Attack cookbook which is available at: http://en.wikibooks.org/wiki/RAC_Attack_-_Oracle_Cluster_Database_at_Home/RAC_Attack_12c/Hardware_Requirements It is a complex configuration and there is always problems to troubleshoot: get Virtual Box be able to run a 64-bits guest, and that might involve some BIOS settings be able to install VirtualBox, and we…

Read More
David Barbarin

Windows Cluster vNext and cloud witness

By | Operation systems | No Comments

The next version of Windows will provide some interesting features about WFSC architectures. One of them is the new quorum type: “Node majority and cloud witness” which will solve many cases where a third datacenter is mandatory and missing to achieve a truly resilient quorum. Let’s imagine the following scenario that may concern the implementation of either an SQL Server availability group or a SQL Server FCI. Let’s say you have to implement a geo-cluster…

Read More
Oracle Team

IOUG Collaborate #C15LV

By | Operation systems, Oracle | No Comments

By Franck Pachot . The IOUG – Independant Oracle User Group – has a great event each year: the COLLABORATE. This year it’s in April 12-16, 2015 at The Mandalay Bay Resort & Casino in Las Vegas. I’ll be a speaker and a RAC Attack Ninja as well.  IOUG COLLABORATE provides all the real-world technical training you need – not sales pitches. The IOUG Forum presents hundreds of educational sessions on Oracle technology, led by…

Read More
David Barbarin

SQL Server 2014: FCIs, availability groups, and TCP port conflict issues

By | Operation systems | One Comment

After giving my session about SQL Server AlwaysOn and availability groups at the last French event “Les journées SQL Server 2014”, I had several questions concerning the port conflict issues, particularly the differences that exist between FCIs and availability groups (AAGs) on this subject. In fact, in both cases, we may have port conflicts depending on which components that are installed on each cluster node. Fundamentally, FCIs and AAGs are both clustered-based features but each…

Read More
David Barbarin

Don’t forget to configure Power Management settings on Hyper-V

By | Operation systems | 3 Comments

Recently I had the opportunity to audit a SQL Server database hosted on a Hyper-V 2012 cluster. I noticed that the guest operating system had the Power Plan configured to High performance. This is great thing but when I talked to the system administrator to verify if the same option is turned on on the Hyper-V operating system, this was unfortunately not the case. As a reminder, the power policy setting has no effect on the…

Read More
Grégory Steulet

FIO (Flexible I/O) – a benchmark tool for any operating system

By | Operation systems | No Comments

I have just attended an interesting session held by Martin Nash (@mpnsh) at UKOUG 14 – Liverpool: “The least an Oracle DBA Should Know about Linux Administration” . During this session I had the opportunity to discover some interesting commands and tools such as FIO (Flexible I/O). FIO is a workload generator that can be used both for benchmark and stress/hardware verification. FIO has support for 19 different types of I/O engines (sync, mmap, libaio, posixaio,…

Read More
Stéphane Savorgnano

Windows Server 2012 R2: solving .NET Framework 3.5 installation problems

By | Operation systems | 25 Comments

I faced a problem at a customer site last week when I tried to install the .NET Framework 3.5 – a prerequisite for installing SQL Server 2012 on a Windows Server 2012 R2. I opened the Server Manager and then navigated to the Manage, Add Roles and Features section: I selected the .NET Framework 3.5 Features option: I specified an alternate source path: … and surprise! Even though an ISO of Windows Server 2012 R2…

Read More
David Barbarin

SQL Server failover cluster, VSphere, & SCSI-3 reservation nightmares

By | Operation systems | No Comments

When I have to install a virtualized SQL Server FCI at a customer place as an SQL Server consultant, the virtualized environment usally is ready. I guess this is the same for most part of the database consulting people. Since we therefore lack practice, I have to admit that we do not always know the good configuration settings to apply to the virtualized layer in order to correctly run our SQL Server FCI architecture. A…

Read More
Oracle Team

Linux: how to monitor the nofile limit

By | Operation systems, Oracle | One Comment

By Franck Pachot . In a previous post I explained how to measure the number of processes that are generated when a fork() or clone() call checks the nproc limit. There is another limit in /etc/limits.conf – or in /etc/limits.d – that is displayed by ‘ulimit -n’. It’s the number of open files – ‘nofile’ – and here again we need to know what kind of files are counted. nofile ‘nofile’ is another limit that…

Read More