Re: ThreadAbort Exceptions !! HELP !!

Well we checked for queued requests last night and there were none during
the busiest 3 hour period of the week. Looks like our SQL server box is
really just this busy. We will have to go down a different road. Thanks
for taking time to respond!

"Patrice" <scribe@xxxxxxxx> wrote in message
news:u5EmrLOVGHA.4792@xxxxxxxxxxxxxxxxxxxxxxx
As this is in WaitOne my first thought would be a timeout. Not an expert
but could it be something like not having enough worker threads to process
incoming requests ? Have you checked performance counters for queued
requests ?

Please let us know.
--
Patrice

"Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> a écrit dans le
message de news: OG5n8tFVGHA.5092@xxxxxxxxxxxxxxxxxxxxxxx
I've seen many blogs address this issue and always end up associating it
with the infamous Response.Redirect without the second parameter. Our
web team assures me they've exhaustively gone thru the entire website and
taken care of this issue on their end.

We still get a handful of these during our busiest times. The stack
trace seems to usually point at a webservice not an aspx page.
For instance...

System.Threading.ThreadAbortException: Thread was being aborted. at
System.Threading.WaitHandle.WaitOneNative(IntPtr waitHandle, UInt32
millisecondsTimeout, Boolean exitContext) at
System.Threading.WaitHandle.WaitOne(Int32 millisecondsTimeout, Boolean
exitContext) at System.Net.HttpWebRequest.GetRequestStream() at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at
WWDBV2.wsOrders.Orders.GetDetailsByOrderID(Int32 lngIBO, String
strSession, Int32 lngOrderID, Boolean blnGetDetails, Boolean
blnIncludeDeleted, ViewModes vm) at WWDBV2.eApp.Details.Page_Load(Object
sender, EventArgs e)


where WWDBV2.wsOrders is a webservice on a different server inside the
firewall. Since our webservices are obviously not redirecting anything
then that is not the issue. During busy times we might have a 5-600
users consistently using our ordering system. With a 4-cluster web
front-end and a 2-cluster webservice middle-tier I'd think we should not
have any performance issues.

Our SQL Server is a single dual-proc machine (soon to be clustered with
another 4-proc box). Our current box rarely goes over 75% CPU and all
other stats are fine. The only thing I haven't personally monitered is
the network stats. The web cluster is wired to the middle tier on a
100MB connection. The middle tier is connected to the SQL box by a
dedicated 1 GB connection so I really cannot imagine bandwidth as a
problem here.

I'm pulling my hair out here and I already don't have enough of that!!
Does anyone have a clue what I could be missing here?

The manager in the web department is freaking out on us and insisting
that the "data guys" have screwed something up.

Thank you for any help ... anything at all.





.

Relevant Pages

  • Re: Newbie question - how to use Web Service function in Access
    ... I guess it would be much easier if the webservice in question supports HTTP ... VBA must have some functions to help with HTTP requests and responses. ... You'll have to make the SOAP Requests and process the SOAP Responses ... The web services developers have provided me 3 ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Select statement for boolean and/or DateTime values?
    ... The above works for an SQL Server, means reader contains the row I'm ... SQL Server does not have a boolean datatype, and even if it did, ... Access DOES have a boolean datatype, but, it requires a nonstandard ... Again, if you utilize parameters, values will be passed correctly to the Jet ...
    (microsoft.public.data.ado)
  • Re: Sql 2005: SSIS - How to convert "N/Y" CHAR(1) to byte type column
    ... below) to represent boolean types. ... i.e. an expression that takes a charconstruction_weld column value from the flat file and converts it to a bit type that is compatible with the construction_weld column in the wl_well_casing_liner table. ... > Before we go further on the issue, I'd like to know which data type you> want to use in SQL server, do you use any tinyint? ... I'm totally unfamiliar the grammar of SSIS expressions> and I ...
    (microsoft.public.sqlserver.dts)
  • Re: Custom membership provider problem
    ... SQL server 2005 does not install with the TCP/IP protocol turned on. ... >An error has occurred while establishing a connection to the server. ... 25 - Connection string is not valid) ... >Boolean& failoverDemandDone, String host, String failoverPartner, String ...
    (microsoft.public.dotnet.framework.aspnet)