we can query the system table **sys.dm_exec_query_stats** to get the last time a stored procedure was executed....

The very first thing I will do is find out the reasons for slowness of the query. The first three things I will do is following: 1. Check the Storage devices on server to ensure that there are enough disk space available for I/O. As it might be my...