I found these videos on how to tweak Azure SQL Database for performance really interesting.
Should apply to on-premise version also, I’d imagine.
Azure SQL for beginners – Special edition on performance
- Introduction
https://www.youtube.com/watch?v=hwdhQn6ve5o - High CPU due to a Missing Index
https://www.youtube.com/watch?v=l1Kr4VRT4-k - High CPU due to anti-pattern queries
https://www.youtube.com/watch?v=2xuIAb437YY - High CPU due to lack of resources
https://www.youtube.com/watch?v=ki6GeQOX-do - Waiting due to Blocking
https://www.youtube.com/watch?v=rj8OWl0ffH8 - Waiting due to deadlocks
https://www.youtube.com/watch?v=HP9CIRe9B7Y - Waiting due to memory grants
https://www.youtube.com/watch?v=kzc-LX7T1lg
Found on the Microsoft Developer channel:
https://www.youtube.com/@MicrosoftDeveloper/videos