Just earlier today when we were fixing the performance of a database during, we found a unique requirement to disable statistics update on a table.
Here is the question asked in my yesterday’s Comprehensive Database Performance Health Check about rows sampled from 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.
In the last 3 months, I have done nearly 11 consulting engagement for Dynamics NAV AX CRM while working on Comprehensive Database Performance Health Check.
During Comprehensive Database Performance Health Check I recently faced a brand new wait type WAIT_ON_SYNC_STATISTICS_REFRESH.
Recently I got the opportunity to work on a very new feature of Persisting Sample Percentage for Statistics. Let us learn today.