BE SHARING

Steven Naudet

SQL Server: Is this ad hoc workload an issue?

17.05.2023 by Steven Naudet

I ran into an interesting scenario with a customer that I want to share in this blog post.This customer is running a data-loading activity on a monthly basis from his business application.He did not complain about the performance, the time(…)

SQL Server

SQL Server: How Correlation assumptions work for multiple predicates

10.04.2023 by Steven Naudet

SQL Server 2022 introduced “CE Feedback“, a feature that adjusts some Cardinality Estimation model assumptions at a query level by applying Query Store hints. In this blog post, I’ll use an example query from the(…)

Database Administration & Monitoring

SQL Server: Heap page deallocation and IndexOptimize

23.01.2023 by Steven Naudet

Introduction HEAP tables are a type of data structure that, unlike a clustered index table, does not have a specific ordering of its rows, making them faster to insert and delete data. They are often used for temporary “staging” tables.

Database Administration & Monitoring

SQL Server Deadlock on UPDATE with Serializable isolation level

10.08.2022 by Steven Naudet

Recently I spent some time on a recurring Deadlock problem on a customer’s site in a high concurrency environment. It was only after finding the solution on my own that I discovered that this particular problem is already well documented(…)

Database Administration & Monitoring

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.