BE SHARING

Author: Steven Naudet

First look at SQL Server 2022 Contained Availability Groups

09.06.2022 by Steven Naudet

Introduction SQL Server 2022 introduces the new concept of Contained Availability Groups. This is something that DBAs have been waiting for since Availability Groups were introduced 10 years ago. Contained Availability Groups enhance the Availability groups by providing the(…)

Database Administration & Monitoring

SQL Server 2022 Parameter Sensitive Plan optimization

01.06.2022 by Steven Naudet

Introduction The Intelligent Query Processing (IQP) feature family is extended with SQL Server 2022.One of the most anticipated features is the Parameter Sensitive Plan optimization. I started to test this new feature. In this post, you will find some(…)

Database Administration & Monitoring

SQL Server 2022 public preview available

31.05.2022 by Steven Naudet

This is a small blog post to share that the SQL Server 2022 public preview is available for download. The Microsoft announcement blog post and a summary of the new feature are available here : Announcing SQL Server 2022(…)

Database Administration & Monitoring

SQL Server: Find who forced a plan in Query Store with this new XEvent

22.04.2022 by Steven Naudet

The latest Cumulative Update for SQL Server 2019 has been released this week on Monday. It brings many bug fixes and some small improvements. One of these improvements is the addition of an extended event to identify the(…)

Database Administration & Monitoring

SQL Server: Automatic Soft-NUMA and uneven CPU load

20.04.2022 by Steven Naudet

SQL Server has CPU limitations depending on the Edition. If your VM is not configured properly you can reach these limits very easily. In a previous post, I described the effect VM misconfigurations can have on performance because not(…)

SQL Server

SQLBits 2022 – Levelling up my Performance Tuning skills

10.03.2022 by Steven Naudet

As a consultant at dbi services, I am lucky enough to have time dedicated to training and conferences. This week I have the chance to attend one of the most important conferences for Data professionals: SQLBits 2022.

Database Administration & Monitoring

dbi Event Recap: SQL Server Automatic Tuning and Query Store

15.11.2021 by Steven Naudet

Earlier this month, dbi services hosted a free multi-technology event. Details are available on our website. I had the opportunity to present a session about the Query Store and the Automatic Tuning feature available on SQL Server and(…)

Database Administration & Monitoring

SQL Server: Is Fill Factor applied during INSERT?

13.11.2021 by Steven Naudet

The Fill factor setting controls the amount of space that is left available on the index data pages. The goal is to allow new rows to be inserted or existing ones to change size (UPDATE) without resulting in(…)

Database Administration & Monitoring

SQL Server: table variables performance limitations

14.07.2021 by Steven Naudet

Doing some performance troubleshooting for one of my customers I identified some issues with very large table variables inside Stored procedures. Table variables limitations are not well understood by developers although they are now well documented. Table variable(…)

Database Administration & Monitoring

SQL Server: Fixing another huge MSDB database – 80GB+

01.07.2021 by Steven Naudet

I have blogged several times about unusually large MSDB databases like here. Most of the time the problem comes from the backup history which is never purged. This time it’s different. Try to guess, if not the(…)