473,322 Members | 1,401 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Timeouts - Disk Queues

Hi

Got a strange problem.

For some reason our web client box times out occasionally. Maybe a
few times a day.

Nothing appears in the logs.

What I do know is that the disk queue ramps up to <high>(think top of
the graph), processor queue jumps up and the tps drops to 0 (naturally
enough!) along with reduced pagefile usage. Usually at this time the
tps is between 20 and 300. Running a pair of mirrored 18gb scsi disks
for the whole server (yeah yeah) and a whopping 640mb memory. Oh and
a single piii 1 gig. Sql2k standard vanilla, server2k.

What server trace events is it worth my catching to try and get a
better Idea of what may be causing this? No major jobs (backups etc
seem to be occuring at these times).

Cheers
Jul 20 '05 #1
1 1499
WangKhar (Wa******@yahoo.com) writes:
For some reason our web client box times out occasionally. Maybe a
few times a day.

Nothing appears in the logs.

What I do know is that the disk queue ramps up to <high>(think top of
the graph), processor queue jumps up and the tps drops to 0 (naturally
enough!) along with reduced pagefile usage. Usually at this time the
tps is between 20 and 300. Running a pair of mirrored 18gb scsi disks
for the whole server (yeah yeah) and a whopping 640mb memory. Oh and
a single piii 1 gig. Sql2k standard vanilla, server2k.

What server trace events is it worth my catching to try and get a
better Idea of what may be causing this? No major jobs (backups etc
seem to be occuring at these times).


Times out? You mean that requests from the web client to SQL Server
dies with "Timeout expired"?

There are a couple of possible explanations to what is going. The two
most likely that comes to mind is:

o Someone somewhere submits a query with a bad execution plan that
takes up a lot of resources and blocks other users.
o Database auto-grow.

The best way to track this is probably to use the Profiler. Set up a
filter to capture Auto-grow events. Also set up a trace for
SQL:StmtCompleted, filtered for a Duration > 1000 ms. It's probably
good to include RPC:Completed and TSQL:BatchCompleted as well.

Or take a shortcut. Do an sp_spaceused and sp_helpdb on the database and on
tempdb, and see how much unallocated space you have in relation to the
size of the data files. If the margin is narrow, increase the size of
the databases with ALTER DATABASE (or use Enterprise Manager) by the
double. If the problem goes away for some time, you know it was auto-grow.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

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

Similar topics

7
by: Anand Pillai | last post by:
The standard Python Queue module, allows to generate queues that have no size limit, by passing the size argument as <= 0. q = Queue(0) In a multithreaded application, these queues could be...
0
by: Aki Niimura | last post by:
Hello everyone. I'm trying to control a program from a Python program using IPC. Although using a socket is a common choice for such applications, I would like to use SysV message queues...
0
by: badtemper | last post by:
Is there any way to use perl or any other programming language to perform a "qchk -A" from a web page and see the listing? My problem is that I manage the network for a medical facility that is...
1
by: saleem | last post by:
Dear friends, I am working on the problem which deals with the data management of requests and how should we match the responses for the requests to compare the correct Response. my problem...
2
by: mircu | last post by:
Hi, I need a quick solution to make my application behave correctly when one of these timeouts occurs. I have some logic in session_start but when the authentication cookie timeouts the user is...
1
by: Safalra | last post by:
A long time ago when I used a browser that didn't support the shift or unshift methods of the array object, I came up with an implementation of queues that guaranteed amortised constant time...
0
by: brianbass | last post by:
I am having a perplexing issue and am wondering if anyone can see the flaw in my setup. I have 3 windows services and 3 message queues. Each service resides in the same directory and they all...
1
by: ericstein81 | last post by:
I am trying to write a program that uses three queues for inputs of numbers. The problem i am having is I am not quite sure how to designate the seperate queues. can they be named as queue(a),...
10
by: Zytan | last post by:
I have a TcpClient. I set the read/write timeouts at 1 minute (in milliseconds). I get a NetworkStream from it and confirm the timeouts still exist. I do a NetworkStream.Write() and then a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.