'Stored Procedure troubleshooting Execution time

There is one Stored procedure. It took 2 minutes to run one day and next day it took almost 10 minutes to run.

There is NO change in code.

So, what could be the general trouble shooting tips to check the stored procedure and it's execution time.

sql sql-server tsql

Solution 1:^[1]

It could be due to stored procedure parameter sniffing.

I recommend this article brentozar parameter sniffing for you understanding.

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1