RE: Website Slow then falls over

Paul Broomfield Thu, 30 Aug 2001 03:46:16 -0700

Thanks for getting back to me.

The function of the apps on the server is a very complicated shopping system. It allows buyers for a large department stores around the world to come to the site and buy the products that will be seen on the shelves next season.

There is a lot of data and very large queries, Stored Proc’s and DTS packages. The reason there is such a large amount of data is imagine if you order a t-shirt it comes in different colours and different sizes, or in other words if you have a t-shirt you could have 10 different sizes in 20 different colours – so the amount of data quickly mounts up.

There is not that many users on the system, say 150ish but when they come to the site they use it very intensely.

BTW I should have made my self a little clearer about how the web and DB server are connected they got a cross over cable going between the two.

Do you think that running each of the sites in its own memory space (Application Protection) would help – does this load the ActiveX into its own space as well?

Thanks

Paul

Paul Broomfield, Network Administrator and Database Technician

Tell Communications

Tamar Science Park

Derriford

Plymouth

Devon

PL6 8BX

Tel: +44 (0) 1752 764242

Fax: +44 (0) 1752 764243

Visit us on the web at: http://www.tell-com.com/

-----Original Message-----
From: Gopalakrishnan [mailto:[EMAIL PROTECTED]]
Sent: 30 August 2001 12:19
To: NT System Admin Issues
Subject: Re: Website Slow then falls over

Could be a memory leak in your ActiveX components. If the sites on your server require input from an external source ,then your sites performance will also depend on that external source (I observed on our servers that an large queues in IIS were causing inetinfo to hang permanently )

have you got any more info on the kind of web apps running on the server.

cheers

gopal

----- Original Message -----

From: Paul Broomfield

To: NT System Admin Issues

Sent: Thursday, August 30, 2001 11:28 AM

Subject: Website Slow then falls over

Hello,

We’re getting a problem on one of our web servers.

Here’s the set-up:

Web Server:

Dell Power Edge 2450

Win2k SP2

IIS 5

Norton Antivirus – set-up to avoid the scanning global.asa, (as opening the global.asa can causing site to stop responding)

Database Server

Dell Power Edge 2450

Win2k SP1 (I’m applying SP2 shortly)

SQL 2000

The web server has a direct connection to the web with no firewall. The database server connects to the web server via a secondary network card in the web server and on a separate IP network and hence hiding the DB server from the outside world.

The web server has 3 sites on it all running different versions of the same site with 3 different versions of our custom built ActiveX component. The 3 sites include - one Live, one customer trial site and one in-house demo/dev site. The customer is testing new developments on the customer trial site, and their customers are using the live site.

The sites work fine and then after a while they will slow and eventually stop responding. The server requires a full restart to get it working again, Inetinfo sits near the bottom of the process list not really doing anything and not using a great deal of memory. I can’t see anything in the process list that is battering the servers’ resources.

We have regressed any new developments we put into the trial site before these problems started to happen, in case it was any strange code making the server crash.

The last weird thing that happened before the sites started playing up, was the web server reported an out of virtual memory error. The websites stopped working, the server then reallocated memory then came back to life, allowing users to access the sites again. One thing we noticed after this is that all dates changed to American format rather than United Kingdom format – so we changed these back and restarted the server for good measure.

Looking through the Event Viewer there is nothing too unusual in there apart from an error saying the SSL is screwed, it really says: “A fatal error occurred while creating an SSL server credential”, although the client has a certificate protected site it is not used. Another error we seem to be getting is script timeouts, but these don’t correlate with server crashes.

We do get lots of CodeRed hack attempts but I patched the server when the hotfix first came out from MS.

Does anybody have any ideas? As I am running out of them.