I have a job in which I have 3 stored procedures and some DML steps, out of which 1 stored procedure is taking long time. I have added some indexes and this job finished quicker than before. I am aware that the slow running sproc finished quicker, but I want to know how long it took to complete that only 1 stored procedure.
How can I find this out? I can't run the stored procedure again from SSMS .
Any suggestions please? Thanks in advance.