Showing posts with label Query Statistics History Report Duration and Execution Time taken. Show all posts
Showing posts with label Query Statistics History Report Duration and Execution Time taken. Show all posts

Friday, June 14, 2013

[SQL Server Data Warehousing] Query Statistics History Report Duration and Execution Time taken


Query Statistics History Report Duration and Execution Time taken



Hi everyone


I have about 4 jobs calling the same stored procedure but each time it runs it executes different Id's. When Job1 is running it may takes 45 minutes for job to complete, Job2 can take 1 hour 20 minutes to run. They basically overlap with each other but touch different Ids that need to be executed.


Questions 1


The stored procedure creates a bunch of #temp tables and I believe each time a job runs every time it goes through the same code and create seperate #temp tables. Like Job1 runs it creates #temp1_1, Job2 runs and creates #temp_2, Job3 runs and creates #temp_3 in memory.


Can you please confirm if my understanding is right.


Question 2


When I check the Query statistics History report I see server queries mentioned in the stored procedure running for hours, but the jobs completes in less than an hour. I am saying hours thinking that time mentioned there is in seconds. First of all is the total duration, execution/minutes is that in Milli seconds or Seconds?


So how is it possible that query shows 6 hours running but none of the job runs for 6 hours straight.


Thanks much


-Sarah




.

social.technet.microsoft.com/Forums

Search This Blog