>You should try to instrument your app and check and see exactly what's taking up the time. Is it startup of the applicaiton? is it individual requests? Is it your SQL connection?
>
>You can hookup Application_Start and Application_End to see if your app is being shut down frequently
The application has already started so it is elsewhere. Also, when the application starts, the log time would be calculated from the point the application initialization would be completed. So, because I have a hit of 5 seconds when this happens, for a hit that takes 0.2, this means something is slowing down somewhere. It is not to a specific hit. It is general. So, when the IIS or SQL Server go in sleep mode, no matter the hit, it will take 5 seconds on the first one. Then, the IIS or SQL Server is back to normal and everything is ok. I will add a trace towards the SQL connection. This is probably where it is.
BTW, the idea of adding a log on start and on end is a good idea. I wonder why I never thought of that in the first place.
I will let you know. Thanks