Remove 2016 Remove Database Remove Servers Remove Virtualization
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
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.

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

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

Common SQL Server Mishaps

SQL Performance

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS.

Servers 49
article thumbnail

AMD EPYC Processors in Azure Virtual Machines

SQL Performance

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. Since then, Microsoft has changed the naming of this series to Lsv2.

Azure 42
article thumbnail

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The Back Story.

Servers 90
article thumbnail

Is MongoDB Open Source? Is Planet Earth Flat?

Percona

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself.