An issue is being experienced and we're not sure where the situation could be.
We have a web site running on a server Window 2012 R2 and IIS 8.5. We had this migrated from a Windows 2003 running IIS 6. The web site application is in .NET. (C#)
The situation we are experiencing is a little strange and hard to pinpoint.
When somebody accesses the page and starts processing, one of the first things it does is a name lookup. In that name lookup, it's basically running a query against the database.
What is happening is the name lookup there is a delay of 5-16 seconds before it will allow activity on the field or the user goes to the next field.
The strange thing is this....we did a SQL Profile on the query that is executing. That thing starts and complete in less than a second which was completely expected.
Now, there are multiple times on the page that the name lookup is done and all subsequent times it takes and the web page responds in less than a second.
So, it appears this first time it performs the lookup
I have looked at the logs in the W3SVC1 and it shows on the 200 with that name lookup that the time taken was 60-253 MS so way less than a second.
Any ideas what might be happening with during this extra time on the first instance so that the delay can be eliminated? Any way we can capture that?
By the way, when this same web site was running in Windows 2003 under IIS 6 this delay was not present.
Any assistance would be greatly appreciated.