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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.
First Responder Kit is excellent. You could also take a quick look with SQL Profiler, watch the CPU, Reads and Writes, it may point you in the right direction. You mentioned "stored procedures slowly sometimes" , you could schedule Profile to run during this period and insert the results into db table for analysis later.