He asked me if I can provide it scientifically my findings and he will immediately approve the budget. Let us see Queries Waiting for Memory Grant.
SQL SERVER – QDS_LOADDB Wait and Asynchronous Load of Query Store
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
Read the statistics modification counter with sys.dm_db_stats_properties, rank changed statistics, and choose focused updates.
Scalar Function Statistics With sys.dm_exec_function_stats
Read dm_exec_function_stats to rank scalar UDF activity, inspect callers, verify collection settings, and recognize inlined work.
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.