Nebulous IIS error: 500 Internal Server Error

Posted on 2012-08-23
Last Modified: 2013-04-08
One of our customers is having this error appear periodically on his client browsers (chrome, firefox and ie) but can clear it by a simple page refresh (undesirable workaround)

This may be a simple bottleneck of system resources starting with RAM but before I go down that road, I want to see if anyone has any better ideas as to a) what is the real problem and b) can it be managed within the current resource constraints?

The server is a 64 bit Windows Server 2008 R2 running in a HyperV env with 32G RAM allocated.  The main application is SQL Server 2008 R2 which is taking 90+% RAM.

We have VB ASP code interfacing between IIS and the SQL server that calling into a DLL to build a graphic chart for display.  The server log error thrown looks like it is coming from our ASP2DLL code which may be from having to cache in that code periodically, given the SQL Server is hogging the memory.  We are experimenting with limiting the RAM that SQL Server will consume which *should* leave more RAM for other system applications to not need to be cached.

We have not been able to reproduce this problem but our customer is seeing in periodically on several clients.  This is a server error, not a client one.

I am attaching a file with datapoints from the server to help with understanding the env and error messages.
Question by:FDC2005
    LVL 82

    Assisted Solution

    by:Dave Baldwin
    Why is 'mmc.exe' using 680 megabytes?  That seems like a lot to me even if it is supposed to be running.
    LVL 25

    Accepted Solution

    High memory is normal for SQL (it's a real hog) however it only becomes an issue if there are other problems at the same time like a high page/sec memory counter.

    Author Comment

    I do not know why mmc.exe (Microsoft Management Console) is taking so much RAM.  The server was last reset in early August.  We are requesting a subsequent server reboot to see whether that will clear the main issue as well as reduce RAM for mmc.exe.

    Author Comment

    Regarding pony10us' comment, since we cannot reproduice this nor have we been logged in during the times when this sporatically hac occured, we don't have a snapshot of the system behavior... which brings up a good point for me to follow up with.  
    I will enable the performance logging and see if we can correlate the errors in the logs with monitor points.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Many admins will agree: WSUS is is a nice invention but using it on the client side when updating a newly installed computer is still time consuming as you have to do several reboots and furthermore, the procedure of installing updates, rebooting an…
    Running classic asp applications under Windows Server 2008 R2 (x64) and IIS 7 is not as easy as one may think. It took me a while to figure it out while getting error 8002801d a few times. After you install the OS you will need to install the fol…
    Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now