I am executing a stored procedure on my machine in SQL Management studio and database is located on another machine(just ans ordinary machine which has 3GB RAM, not a server)
Stored procedure works properly, but every time it takes different time to execute even if all parameters are the same. Execution time varies from 1 minutes to 8 minute. I am not able to find reason for this and i am not using any DBCC command in between.
Though i understand that memory/CPU availability of server plays a role here, i am still not able understand the reason.
Please share your thoughts on this