Monitor by using Extended Events
Monitor by using Query Store
Identify sessions that cause blocking
Identify performance issues using dynamic management views (DMVs)
Identify and implement index changes for queries
Recommend query construct modifications based on resource usage
Assess the use of query hints for query performance
Implement index maintenance tasks
Implement statistics maintenance tasks
Implement database integrity checks
Configure database automatic tuning
Configure server settings for performance
Configure Resource Governor for performance
Implement database-scoped configuration