article thumbnail

SQL 2016 – It Just Runs Faster Announcement

SQL Server According to Bob

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations.

article thumbnail

SQL Server 2016 – It Just Runs Faster: Always On Availability Groups Turbocharged

SQL Server According to Bob

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

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

USENIX LISA2021 Computing Performance: On the Horizon

Brendan Gregg

This was a chance to talk about other things I've been working on, such as the present and future of hardware performance. BBR: Congestion-Based Congestion Control,” [link] 2016 - [Gregg 16] Brendan Gregg, “Unikernel Profiling: Flame Graphs from dom0,” [link] Jan 2016 - [Gregg 16b] Brendan Gregg, “Linux 4.X

article thumbnail

Netflix Now Streaming AV1 on Android

The Netflix TechBlog

For our mobile environment, AV1 follows on our work with VP9, which we released as part of our mobile encodes in 2016 and further optimized with shot-based encodes in 2018. Our support for AV1 represents Netflix’s continued investment in delivering the most efficient and highest quality video streams.

Media 160
article thumbnail

Netflix Now Streaming AV1 on Android

The Netflix TechBlog

For our mobile environment, AV1 follows on our work with VP9, which we released as part of our mobile encodes in 2016 and further optimized with shot-based encodes in 2018. Our support for AV1 represents Netflix’s continued investment in delivering the most efficient and highest quality video streams.

Media 160
article thumbnail

How It Works: SQL Server 2016 SSE/AVX Support

SQL Server According to Bob

As indicated, SQL Server 2016 added the use of SSE and AVX instructions in various code paths to improve performance. SQL Server asks the CPU if it supports SSE or AVX in order to determine the level of hardware support present on the system. My recent posts. have generated discussions about the SSE and AVX support boundaries.

Servers 40
article thumbnail

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

SQL Server According to Bob

SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. On the same hardware/machine repeat steps 1 thru 3 using an instance of SQL Server 2016 CTP 3.0