472,805 Members | 2,778 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,805 software developers and data experts.

performance: IIS - Sqlserver locks influence???

Hi there,

We have a web application handling thousands of requests per seconds reading
sql server data which is heavily updated.
We are generally experiencing no performance problems.
On some occasions we get an increase of the traffic of about 15% for short
periods. In this case we observe something really strange: our webserver
CPU goes from about 40% usage to 100%, with memory usage keeping low (about
50%). We see at the same time that the number of sqlserver locks increases.
Are these 2 behaviours correlated? ..or any other ideas?
We are using w2k and sql2K

Thanks for your help

Alex

Nov 18 '05 #1
4 1849
"Alex Callea" <al*********@sellys.com> wrote in message
news:O2**************@TK2MSFTNGP09.phx.gbl...
Hi there,

We have a web application handling thousands of requests per seconds
reading sql server data which is heavily updated.
We are generally experiencing no performance problems.
On some occasions we get an increase of the traffic of about 15% for short
periods. In this case we observe something really strange: our webserver
CPU goes from about 40% usage to 100%, with memory usage keeping low
(about 50%). We see at the same time that the number of sqlserver locks
increases.
Are these 2 behaviours correlated? ..or any other ideas?


The traffic increases by 15%. The traffic passes through IIS. The
application in IIS calls SQL Server.

If I'm right, then this suggests that the behaviors correlate.

John Saunders
Nov 18 '05 #2
I know it's correlated but my question was to know if the increase number of
locks had cpu usage consequences on IIS.

We already noticed that the number of web requests being processed has huge
impact on webservers CPUs.
I'd like to know if the same apply with SQL locks(e.g. ADO.NET objects need
to wait more resulting in an increase of page processing time, etc...) as
the SQL server CPUs are almost not impacted by the increased traffic.
Thanks

Alex

"John Saunders" <johnwsaundersiii at hotmail.com> wrote in message
news:eI**************@TK2MSFTNGP14.phx.gbl...
"Alex Callea" <al*********@sellys.com> wrote in message
news:O2**************@TK2MSFTNGP09.phx.gbl...
Hi there,

We have a web application handling thousands of requests per seconds
reading sql server data which is heavily updated.
We are generally experiencing no performance problems.
On some occasions we get an increase of the traffic of about 15% for
short periods. In this case we observe something really strange: our
webserver CPU goes from about 40% usage to 100%, with memory usage
keeping low (about 50%). We see at the same time that the number of
sqlserver locks increases.
Are these 2 behaviours correlated? ..or any other ideas?


The traffic increases by 15%. The traffic passes through IIS. The
application in IIS calls SQL Server.

If I'm right, then this suggests that the behaviors correlate.

John Saunders

Nov 18 '05 #3
"Alex Callea" <al*********@sellys.com> wrote in message
news:uQ**************@TK2MSFTNGP15.phx.gbl...
I know it's correlated but my question was to know if the increase number
of locks had cpu usage consequences on IIS.

We already noticed that the number of web requests being processed has
huge impact on webservers CPUs.
I'd like to know if the same apply with SQL locks(e.g. ADO.NET objects
need to wait more resulting in an increase of page processing time,
etc...) as the SQL server CPUs are almost not impacted by the increased
traffic.


Alex, I am certainly not an expert on IIS performance, but I can't think why
it would in any way be affected by SQL Server locks.

John
Nov 18 '05 #4

"John Saunders" <johnwsaundersiii at hotmail.com> wrote in message
news:uE*************@TK2MSFTNGP11.phx.gbl...
"Alex Callea" <al*********@sellys.com> wrote in message
news:uQ**************@TK2MSFTNGP15.phx.gbl...
I know it's correlated but my question was to know if the increase number
of locks had cpu usage consequences on IIS.

We already noticed that the number of web requests being processed has
huge impact on webservers CPUs.
I'd like to know if the same apply with SQL locks(e.g. ADO.NET objects
need to wait more resulting in an increase of page processing time,
etc...) as the SQL server CPUs are almost not impacted by the increased
traffic.


Alex, I am certainly not an expert on IIS performance, but I can't think
why it would in any way be affected by SQL Server locks.

The relationship is probably indirect. Sql Server locks are a directly
related to the volume of work being done by Sql Server. Locks don't
indicate that clients are waiting, just that they are doing stuff. Reading
tables generates shared locks, updating tables generates update or exclusive
locks, etc. So the more work, the more locks.

David
Nov 18 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: writeson | last post by:
Hi all, I've got a PHP program that I've added flock() to in order to protect multiple scripts trying to write to the same file. After I added the flock() to the code the performance of the code...
3
by: Andy Tran | last post by:
I built a system using mysql innodb to archive SMS messages but the innodb databases are not keeping up with the number of SMS messages coming in. I'm looking for performance of 200 msgs/sec where...
4
by: Mee Yamo | last post by:
Fellas!! This is a very complicated one and it took me a few days to figure out exactly what's going on, but here's the final story: I have a production environment running on .NET with a SQL...
2
by: Gary Whitten | last post by:
We have a JDBC project that works with SQLServer, along with other DBs. During development, we noticed that resource useage on SQLServer seemed to grow steadily - Processes, Process Locks and/or...
1
by: php newbie | last post by:
I have the Transact-SQL Programming book from O'Reilly. It was published in 1999. It states that "SELECT ... INTO" statements end up locking the entire database of the target table. Since the...
4
by: Matik | last post by:
Hi, I have a small theoretical issue. I have one table, which is prettyu large. There is lot of evaluations running on this table, that's why, each process need to wait for another to be...
6
by: George McLean | last post by:
Hello, I am trying to isolate some performance issues. The database is DB2 v8.1 running on a Win2000 server with 4 processors and 1gb of RAM. The application is a GIS application that uses...
46
by: dunleav1 | last post by:
I have a process that does inserts that runs 50% slower that Oracle and Mssql. Queries normally take 50% slower than normal. DB2, Oracle, Mssql all are configured on same os, same disk array...
7
by: Roger | last post by:
This is the vba code Set db = CurrentDb On error goto fErr . loop strSql = "UPDATE tblInvAnalysisWhse" & _ " SET ltDeviation = " & Sqr(dblError / intPeriods) & _ " WHERE item = '" &...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: lllomh | last post by:
How does React native implement an English player?
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.