Click here to Skip to main content
14,458,411 members
Rate this:
Please Sign up or sign in to vote.
Hello,

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

Thanks
Posted
Comments
   
This is not a real-time system to guarantee some maximum latency. Results depends on current operating environment status, a combination of several pseudo-random factors. And the network is also random and not real-time, by its very design.
—SA
Amol_B 7-Jun-13 2:05am
   
Thanks Sergey.
I tried to keep CPU Usage and other things similar.
I understand that plan cache reuse plays important part here but still there is lot of variation in execution time
   
Good. Anyway, I wish you a good optimization of your solution throughput.
—SA

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

   
Comments
Amol_B 9-Jun-13 4:00am
   
Good links, +5!
Thanks
Maciej Los 9-Jun-13 15:40pm
   
Thank you, Amol_B ;)
Can you mark this anwer as solved (green button)?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100