article thumbnail

tempdb Enhancements in SQL Server 2019

SQL Performance

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. Now that 2019 CTP 3.2 I have SQL Server 2019 CTP 3.2

Servers 95
article thumbnail

SQL Server 2019 Cumulative Update #1

SQL Performance

Earlier this week, Microsoft announced SQL Server 2019 Cumulative Update #1. To download: For Windows, you can always download the latest 2019 CU here. To update your local Docker image: docker pull mcr.microsoft.com/mssql/server: 2019 -latest. The build number is 15.0.4003.23 and there are 83 fixes !

Servers 52
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

SQL Server 2019 new features: Batch Mode on Rowstore

SQL Shack

In this article, we will explain batch mode on rowstore feature, which was announced with SQL Server 2019. The main benefit of this feature is that it improves the performance of analytical queries, and it also reduces the CPU utilization of these types of queries.

Servers 64
article thumbnail

Thoughts on SQL Server 2019 Editions

SQL Performance

As I embark on my first PASS Summit in a few years, it is hard to contain my excitement about the newest version of SQL Server. As you may recall, back in SQL Server 2016 SP1, they opened up all of the programming surface features to all editions, and many (but certainly not all) of the performance and availability features.

Servers 40
article thumbnail

Connecting MongoDB to Ruby with Self-Signed Certificates for SSL

Scalegrid

In this blog, we’ll show you how to connect to a MongoDB server configured with self-signed certificates for SSL using both the Ruby MongoDB driver and the popular Object-Document-Mapper (ODM) mongoid. servers.mongodirector.com:27017/test?replicaSet=RS-example-0&ssl=true" default: admin) auth_source: test.

C++ 100
article thumbnail

SQL Server TempDB database and Latch Contention

SQL Shack

In this article, we will learn latch contention issues that we might experience in the SQL Server TempDB database. Especially, we will mention the Memory-Optimized TempDB Metadata feature that was introduced with the SQL Server 2019. We will also discuss reasons and the solution method of these latch contention issues.

article thumbnail

Measuring Performance With Server Timing

Smashing Magazine

Measuring Performance With Server Timing. Measuring Performance With Server Timing. 2019-04-29T18:34:58+00:00. That issue is slow server response times. There’s very little browser optimisations can do to improve a page that is simply slow to build on the server. The Server Timing Header. Drew McLellan.

Servers 87