article thumbnail

Install SQL Server 2019 on Windows Server 2016 with SQL Server Always On Availability Groups

SQL Shack

In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations. A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016 Configuration of virtual machines on Oracle […].

Servers 69
article thumbnail

Explore SQL Server PolyBase External Tables in SQL Server Always On Availability Groups

SQL Shack

In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups. SQL Server PolyBase Introduction It is a new feature from SQL Server 2016 to query the relational and non-relational database using data virtualization techniques.

Servers 99
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Configure Domain Controller and Active Directory for SQL Server Always On Availability Groups

SQL Shack

In this series for SQL Server Always On availability groups, we are covering end to end configurations for SQL Server 2019 on Windows Server 2016. In this article, we […].

article thumbnail

AWS EC2 Virtualization 2017: Introducing Nitro

Brendan Gregg

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. It's an exciting development in cloud computing: hardware virtualization is now fast. Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds.

article thumbnail

The SQL Server Transaction Log, Part 2: Log Architecture

SQL Performance

The transaction log contains virtual log files, which contain log blocks, which store the actual log records. Virtual Log Files. The transaction log is split up into sections called virtual log files , commonly just called VLFs. Due to this problem, in SQL Server 2014 the algorithm changed for auto-growth of the log file.

article thumbnail

What is container orchestration?

Dynatrace

Originally developed as a research project at the University of California, Berkeley, in 2009, Mesos launched formally as a mature product in 2016 under the auspices of the Apache Software Foundation, a decentralized open source community.

article thumbnail

USENIX SREcon APAC 2022: Computing Performance: What's on the Horizon

Brendan Gregg

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory.