Stephan du Preez
Guest
|
 Posted:
Mon Dec 06, 2004 2:15 pm Post subject:
Site Performance issue with 500 IIS connections |
|
|
We are running Windows 2003 Standard with IIS 6 on two servers with Commerce
Server 2000. One server is used for http requests and the other for https.
The sites on both machines connect to a SQL Server 2000 machine, also on
Windows 2003 (Enterprise). SQL Server 2000 and Full text indexing server
runs on this machine. About 95% of all calls to the database are stored
procedure calls. The site makes use of the Commerce Server basket, shopper
and pipeline components, but include a lot of customization. There are no
other sites running on the machines. We make use of ADO connections to
database (version 2.7).
When about 500 IIS connections are reached on the http web server, we start
to see a large queue building up on the http box. At this time about 150
connections on the https box. The sites slow down and most requests seem to
time out.
At this point there seems to be a many locks on our basket table on the
database. Many of the stored procedures that normally take a couple of
milliseconds to execute now take up to 40 seconds. We also notice that the
processor activity on the SQL box drops by about 25%.
When we run performance monitor on various SQL counters, there seems to be a
lot of page faults and paging on the server? There is about 5 Gig memory on
the box of which SQL Server uses 3.5Gig.
Web Servers Spec (x2)
----------------
OS Name Microsoft(R) Windows(R) Server 2003, Standard Edition
Version 5.2.3790 Build 3790
System Manufacturer Compaq
System Model ProLiant ML370 G3
System Type X86-based PC
Processor x86 Family 15 Model 2 Stepping 5 GenuineIntel ~3184 Mhz
Processor x86 Family 15 Model 2 Stepping 5 GenuineIntel ~3184 Mhz
Processor x86 Family 15 Model 2 Stepping 5 GenuineIntel ~3184 Mhz
Processor x86 Family 15 Model 2 Stepping 5 GenuineIntel ~3184 Mhz
BIOS Version/Date Compaq P28, 5/1/2004
SMBIOS Version 2.3
Windows Directory C:\WINDOWS
System Directory C:\WINDOWS\system32
Boot Device \Device\HarddiskVolume1
Locale United States
Hardware Abstraction Layer Version = "5.2.3790.0 (srv03_rtm.030324-2048)"
Time Zone South Africa Standard Time
Total Physical Memory 4,096.00 MB
SQL Server Spec
---------------
OS Name Microsoft(R) Windows(R) Server 2003, Enterprise Edition
Version 5.2.3790 Build 3790
OS Manufacturer Microsoft Corporation
System Manufacturer HP
System Model ProLiant ML570 G2
System Type X86-based PC
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
BIOS Version/Date HP P32, 12/10/2003
SMBIOS Version 2.3
Windows Directory C:\WINDOWS
System Directory C:\WINDOWS\system32
Boot Device \Device\HarddiskVolume1
Locale United States
Hardware Abstraction Layer Version = "5.2.3790.0 (srv03_rtm.030324-2048)"
Total Physical Memory 5 GB |
|
David Messner [MSFT]
Guest
|
| Posted:
Thu Dec 30, 2004 5:02 am Post subject:
RE: Site Performance issue with 500 IIS connections |
|
|
| Quote: | We are running Windows 2003 Standard with IIS 6 on two servers with
Commerce |
Server 2000
Support for Windows 2003 wasn't added until Commerce Server 2002 SP3, so I
don't believe you are in a supportable configuration.
| Quote: | At this point there seems to be a many locks on our basket table on the
database. |
The OrderGroup component uses "with rowlock" hints so that only single rows
in the Basket table are locked at a time. If you are hitting deadlocks or
contention then this typically indicates a coding or testing error such
that you have more than one request simultaneously accessing the same row
(which normally wouldn't happen since a single user would not normally be
requesting more than one page with the basket on it at a time).
Have you analyzed the locks using sp_lock or similar?
Sorry, there's not a lot to go on here, these sorts of problems tend to be
very complex to isolate.
regards
-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation. All rights
reserved.
--------------------
Thread-Topic: Site Performance issue with 500 IIS connections
thread-index: AcTba7AtEJjm/KQ3Tu21ubNP4vl/CQ==
X-WBNR-Posting-Host: 196.2.131.57
From: "=?Utf-8?B?U3RlcGhhbiBkdSBQcmVleg==?=" <Stephan du
Preez@discussions.microsoft.com>
Subject: Site Performance issue with 500 IIS connections
Date: Mon, 6 Dec 2004 00:15:03 -0800
Lines: 70
Message-ID: <C974675B-179B-4B83-8A4E-BBF096528230@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA06.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:15197
X-Tomcat-NG: microsoft.public.commerceserver.general
We are running Windows 2003 Standard with IIS 6 on two servers with
Commerce
Server 2000. One server is used for http requests and the other for https.
The sites on both machines connect to a SQL Server 2000 machine, also on
Windows 2003 (Enterprise). SQL Server 2000 and Full text indexing server
runs on this machine. About 95% of all calls to the database are stored
procedure calls. The site makes use of the Commerce Server basket, shopper
and pipeline components, but include a lot of customization. There are no
other sites running on the machines. We make use of ADO connections to
database (version 2.7).
When about 500 IIS connections are reached on the http web server, we start
to see a large queue building up on the http box. At this time about 150
connections on the https box. The sites slow down and most requests seem
to
time out.
At this point there seems to be a many locks on our basket table on the
database. Many of the stored procedures that normally take a couple of
milliseconds to execute now take up to 40 seconds. We also notice that the
processor activity on the SQL box drops by about 25%.
When we run performance monitor on various SQL counters, there seems to be
a
lot of page faults and paging on the server? There is about 5 Gig memory
on
the box of which SQL Server uses 3.5Gig.
Web Servers Spec (x2)
----------------
OS Name Microsoft(R) Windows(R) Server 2003, Standard Edition
Version 5.2.3790 Build 3790
System Manufacturer Compaq
System Model ProLiant ML370 G3
System Type X86-based PC
Processor x86 Family 15 Model 2 Stepping 5 GenuineIntel ~3184 Mhz
Processor x86 Family 15 Model 2 Stepping 5 GenuineIntel ~3184 Mhz
Processor x86 Family 15 Model 2 Stepping 5 GenuineIntel ~3184 Mhz
Processor x86 Family 15 Model 2 Stepping 5 GenuineIntel ~3184 Mhz
BIOS Version/Date Compaq P28, 5/1/2004
SMBIOS Version 2.3
Windows Directory C:\WINDOWS
System Directory C:\WINDOWS\system32
Boot Device \Device\HarddiskVolume1
Locale United States
Hardware Abstraction Layer Version = "5.2.3790.0 (srv03_rtm.030324-2048)"
Time Zone South Africa Standard Time
Total Physical Memory 4,096.00 MB
SQL Server Spec
---------------
OS Name Microsoft(R) Windows(R) Server 2003, Enterprise Edition
Version 5.2.3790 Build 3790
OS Manufacturer Microsoft Corporation
System Manufacturer HP
System Model ProLiant ML570 G2
System Type X86-based PC
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
Processor x86 Family 15 Model 2 Stepping 6 GenuineIntel ~2999 Mhz
BIOS Version/Date HP P32, 12/10/2003
SMBIOS Version 2.3
Windows Directory C:\WINDOWS
System Directory C:\WINDOWS\system32
Boot Device \Device\HarddiskVolume1
Locale United States
Hardware Abstraction Layer Version = "5.2.3790.0 (srv03_rtm.030324-2048)"
Total Physical Memory 5 GB |
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in