Jan Studenovsky

Database Services Director

1
Blog posts
SQL Server statistics update
Improve SQL Server statistics update 1000 times faster than traditional approaches
22 Aug 2019

One of the customers contacted DB Best to help address performance issues with their SQL Server application. They started experiencing problems after upgrading from SQL Server 2008 R2 up to SQL Server 2016. However, after we analyzed their database system, we discovered a complex issue with updating SQL Server statistics. The Query Optimizer uses these statistics to create an execution plan for each query. Specifically, the time to update statistics was taking longer than the planned maintenance window for their production system. The problem After our customer upgraded their database to SQL Server 2016, the lack of current statistics severe...