HTTP Time-Taken and Actual page Rendering in IIS 8.5 on Win 2012 R2

Hi,

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.
LVL 1
davismAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kamal KhaleefaInformation Security SpecialistCommented:
make sure that all connections to data base are  closed and you didn't miss any open connection.

also try to run adds on like developer toolbar and check what is being called
davismAuthor Commented:
king2002,  but if the DB was open and all would that not have been present and cause a delay in the Win 2003 IIS 6 use then too?

Also, what do you mean by "...run adds on like developer toolbar and check what is being called".
Kamal KhaleefaInformation Security SpecialistCommented:
i mean to run the F12 IE Developer toolbar

https://msdn.microsoft.com/en-us/library/gg589507%28v=vs.85%29.aspx

also what do you mean by name lookup?
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Dan McFaddenSystems EngineerCommented:
Can you post some more info from your https logs?  10 lines before the page hit and 10 lines after?

Have you looked into the Application Event Log for any ASP.NET errors?

In your code, what is happening after the query is executed?

Dan
davismAuthor Commented:
Unfortunately, that section of the code we do not have the access to and see.

It's basically event driven on the field in the screen so basically the even is an OnExit of the field and when that happens then the code is fired.

There is no information in the Application Log.
Dan McFaddenSystems EngineerCommented:
Can you post some entries from http logs on the server?

And recommended, I would profile the page using either the F12 tools in IE or with the Web Developer Tools in FF.

It's extremely hard to troubleshoot a problem when we cannot look into the https logs or get some sort of frontend activity log.

Dan

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
davismAuthor Commented:
I ended up just taking the thing out. It was unexplainable and the code was unavailable. :-(

Thanks for your guys' input!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft IIS Web Server

From novice to tech pro — start learning today.