SQL Server tuning advisor
Wed, Jan 9, 2019 · 1 minute readsql server
Short note by way of a memory jogger.
Before the database engine tuning advisor can be used it must be initialised by a user who is a member of the sysadmin role.
Initialisation will create several objects in the msdb database.
After initialisation any user who is a member of the db_owner database role can run tuning advisor.
See Microsoft documentation for detailed instructions on starting tuning advisor and creating workloads.