The client who has SQL Server 2017 faced a very high wait type of QDS_LOADDB. The way to fix it is to enable the Asynchronous Load of Query Store.
SQL SERVER – Total Number of Partitions Created by Partition Function
The next task for us was to find out how many partitions so far has been created by the same partition function. Let us learn about that today.Â
SQL SERVER – Statistics Modification Counter – sys.dm_db_stats_properties
Let us learn about it in today’s blog post about the Statistics Modification Counter. The answers to this question is also very simple.
SQL SERVER – Data Pages In Memory Buffer Pool – sys.dm_os_buffer_descriptors
We reached the point to investigate the data in memory for a single database. Here is the script to list all the database pages in SQL Server Buffer Pool.
SQL SERVER – List All Memory Optimized Tables in TempDB
I received a very interesting question from my client. The question was about how to list all the Memory Optimized Tables in TempDB.
SQL SERVER 2019 – Memory-Optimized TempDB and RESOURCE_SEMAPHORE Wait Type
After looking at the execution plan, I realized it was actually built for a very simple query. Today let us discuss Memory-Optimized TempDB and Performance.
SQL SERVER – Visible Offline Scheduler and Performance
Not every problem is complex but all the problems are for sure interesting. Today we will discuss Visible Offline Scheduler and Performance.Â