We are chasing an odd problem.
We see a significant perf delta when restoring via SSMS, but do NOT see the delta when restoring via TSQL.
When we restore, using SSMS, on SQL 2016 from a DB created on a SQL 2014 instance, the restore is really really slow.
But, on the same SQL 2016 DB server, when we restore from a SQL 2016 instance, again in SSMS, the restore is super fast.
The SQL 2016 system is a super fast system, all-SSD, etc. It should always be fast.
To address, we applied all OS and SQL patches and updates to the target system. Problem was not changed.
Why would restoring a SQL 2014 DB be so slow?