.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

ExecutionLog2 timing discrepancies

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :Sql Server


I've been querying the ExecutionLog2 view a bit lately on my SQL 2008 R2-instance and it seems that there is a discrepancy in the timing columns. If i do a DATEDIFF(ms, TimeStart, TimeEnd) it does not equate to the sum of (TimedataRetrieval + TimeProcessing + TimeRendering). Why is this? What it it that's going on that is not defined as TimedataRetrieval, TimeProcessing or TimeRendering? The difference is quite substantial, some times over a second.

Here is the query I use:

 TotalMS1 = DATEDIFF(ms, TimeStart, TimeEnd), 
 TotalMS2 = TimedataRetrieval + TimeProcessing + TimeRendering,
 Diff = DATEDIFF(ms, TimeStart, TimeEnd) - (TimedataRetrieval + TimeProcessing + TimeRendering)
from ExecutionLog2


View Complete Post

More Related Resource Links

Workflow timing issues?


I am creating a new workflow using SPD on MOSS 2007, SP2, and having a problem with it.

The workflow is fairly basic, where when a user creates a new infopath form it sends an email to another person, who enters some info, then selects where it get's routed to next.  There are 3 more similar processes before the form is marked as completed.  At each step the WF emails the person selected as next reciepient and updates a "flag" saying which step the process is in.

The problem is that sometimes when I update a form, (all emails come to me since it's still in testing), the workflow stops with a message of "Failed on Start (retrying)".  After doing some digging I found this link:


So I went in and added an action for every update I do to first check the document out, do the update, and then check the document back in.  Well the problem I get now is that the WF fails with a message about unable to check the document back in.  I tried troubleshooting it by putting in WF Stop and Log entry actions to try to figure out exactly where the problem was happening.

I thought I had fixed it

SoundPlayer Load / Play timing

I'm trying to create an application where I need sounds to play and pictures to appear at very precise times. So I have a sound that is suppose to play at, let's say 100 ms after something else happened. I'm using SoundPlayer.Play to play the sound on a Thread.Timer tick and that seems to work. However, the first play is slightly delayed (by ~40-50 ms) because it has to load the .wav file before it can play it. So, I tried using SoundPlayer.Load to load the file before I need to play the sound. However, this doesn't seem to make a difference. The only way I can make sure the first play occurs at the right time is to play the sound in advance (before opening the Window where all this occurs). Why doesn't SoundPlayer.Load seem to actually load the wav file completely? And how can I make sure the sound is loaded (preferably without having to play it).

got a question about timing response from the IIS webserver for ASP.NET & WCF

Hi, I am developing an ASP.NET web forms that will talk to IIS 7.0 (WAS & application pool). I read that if the IIS receive requests and the WCF service is busy with a previous request, it will start up another worker thread to process the user request so that the user do not have to wait for a long time and time out.. How do I configure or  code the IIS to get a good acceptable timing response? what is an acceptable time response? Beside buying load balance hardware and software, can I just configure the IIS to instantiate up to a max number of additiona worker thread of that popular WCF service in the application pool to process all the requests to avoid the request just sitting in the queue for too long? Any help is greatly appreciated...   

Distributed Query Timing out



We have created a linked server to a SSAS 2008 Cube on our SQL 2005 server , and tested this..Works fine. Now we are trying to run a MDX query through OPEN QUERY from our server. The query runs for about 10 minutes and times out. So we set the Remote Query timeout to "0" on our server and ran the OPEN QUERY. But still it times out after 10 minutes or so.

Any suggestion to solve this issue?

Thanks in Advance!


Please solve the Database problem (calculate the in and out timing) screech Card in and out timings.

Hey, Dear Friends.. Goody, I need a help from you people. Those who know the more database(prosegers) please salve this problem. The following is my database table. In that, want to calculate each employee out time and in time. I mean how much hr they are spending out side of the company and how much hours they are spending inside of the company in that day. Thanks in Advance. SuraReddy. Emani empcode CardNo emp_code_name time IOGateNo Door in_out date 0022 0022 XYZ 09:09:50 02-1 MAIN DOOR(I/O) Entry 2010-09-08 0022 0022 XYZ 09:50:40 02-5 MAIN DOOR(I/O) Exit 2010-09-08 0022 0022 XYZ 10:02:31 02-1 MAIN DOOR(I/O) Entry 2010-09-08 0022 0022 XYZ 11:31:56 02-5 MAIN DOOR(I/O) Exit 2010-09-08 0022 0022 XYZ 11:45:25 02-1 MAIN DOOR(I/O) Entry 2010-09-08 0022 0022 XYZ 13:48:51 02-5 MAIN DOOR(I/O) Exit 2010-09-08 0022 0022 XYZ 14:30:25 02-1 MAIN DOOR(I/O) Entry 2010-09-08 0022 0022 XYZ 16:16:15 02-5 MAIN DOOR(I/O) Exit 2010-09-08 0022 0022 XYZ 16:33:27 02-1 MAIN DOOR(I/O) Entry 2010-09-08 0022 0022 XYZ 18:40:58 02-5 MAIN DOOR(I/O) Exit 2010-09-08 0022 0022 XYZ 09:04:41 02-1 MAIN DOOR(I/O) Entry 2010-09-09 0022 0022 XYZ 10:21:22 02-5 MAIN DOOR(I/O) Exit 2010-09-09 0022 0022 XYZ 10:30:06 02-1 MAIN DOOR(I/O) Entry 2010-09-09 0022 0022 XYZ 12:44:43 02-5 MAIN DOOR(I/O) Exit 2010-09-09 0022 0022 XYZ 09:08:24 02-1 MAIN DOOR(I/O) Entry 2010-09-14 0022 0022 XYZ 09:43:29 02-5

Which profiler events I need to capture to find out timing out queries?



I understand how can I capture long running quieries based on duration. But I'm trying to figure out how I can do it with quiry which are timing out? For example if ASP.NET executes a query against SQL server and it did not completely within say 60s, will that even be written in profiler as RCP:Completed or it would not be written at all since ASP.NET will kill connection at that point and return error to user?





Search function timing out


I have a find form, when i do a keyword search it is taking more than 30 seconds, exactly after 30 seconds my front end aspx form showing a message saying alert execsp timed out.


Is there a way to increase the timeout limit, it seems like it is defaulted to 30 seconds.


Thank you very much for the helpful info.

WCF One-Way Callbacks Timing Out?


How is this possible?  I thought one way calls were fire and forget.  The method is marked as one-way.  The callback concurrency mode is set to Multiple and the UseSychronizationContext of the callback class is set to false.  The data being sent is not more than 1KB yet every time I send about 30-40 small messages concurrently, the calls start to block and eventually some of them timeout.

I noticed that on the first batch of messages I get dropped connections and time outs randomly.  On the next batch, they come in instantly.  Then if I try a batch again maybe a minute later, its back to coming in slow.  This is atrocious performance, I'm seriously considering changing all my messaging to smart sockets or something.  i have never seen such poor performance in a messaging layer, the fact that it's unpredictable is what gets me.  Either be slow or fast, don't be one or the other every few minutes. 

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend