SQL Server tuning advisor


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.

Comment on this article using form below. Requires email login only for authentication. HTML forbidden, Markdown only.