Using Query Store with least privileges instead of db_owner to archive Separation of Duties
When using the Query Store in a production environment, sometimes customers need to delegate very specifically who can do what in terms of Performance Analysis and/or Tuning. The Query Store is a component that can be activated per database and is used for troubleshooting query performance. If you want to understand, how Query Store works …