This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
I did some test , migration SQL Server to Azure sql database using BACPAC export import method will missed out the '_WA*' auto created statistics ...
how to solve it ?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
_WA_sys stats are auto-created stats. They are not scripted. If needed, they will be recreated by the engine.
Please see:
https://www.mssqltips.com/sqlservertip/2734/what-are-the-sql-server-wasys-statistics/
missing the auto create stats will affect the performance ... how usually customer deal with it ?
if there are thousands of these auto-created stats, and don't moved to Azure SQL Database. would be a disaster .!!!!!
They may not affect anything. They may have been used once and never again.
When auto-statistics are on, they will be recreated if needed again.
Hi @sakuraime ,
Using EXEC sp_updatestats to update statistics after migrating the database to Azure DB. This include auto-created stats.
If the response is helpful, please click "Accept Answer", thank you.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
That doesn't help if the auto-stats wasn't transferred in the first place... :-)
agree ...that's not the solution