How to trouble shoot intermittently slow SQL Server I have a Sql Server that runs stored procedures slowly sometimes. I’d assume it was a problem with the contents of the stored procedures, but sometimes it’s slow to update stored procedures.

Where does one start?
I've run into this several times: new server, hand-me-down, etc. etc.

I always start with the First Responder Kit from the BrentOzar team.  It's always allowed me to quickly diagnose issues and take preventative measures to mitigate future issues.

https://www.brentozar.com/first-aid/