Tag Archives: SQL

Automatic Memory Management for SQL Server Failover Cluster Instances

automatic-memory-management

Memory management One of the challenges while using Failover Cluster Instances (FCI) is to manage the memory of the SQL server in case of failover. In general, most SQL Server configurations do not require much attention to memory management beyond the initial configuration. However, Failover Cluster Instances (FCI) architecture is very different from others. Therefore, …

SQL Server Migration from 2008 R2 to 2016

fci-architecture

Take a read about real-live experience coming from SQL Server migration project I participated in. We migrated from SQL Server 2008 R2 standalone servers into SQL Server 2016 in Failover Cluster Instances (FCI). Watch the full presentation – Polish language only! Intro The environment is a private cloud dedicated to one application using SQL Server …