Re: IISState File Help Needed

From: David Trebacz (trebacz_at_msn.com)
Date: 06/02/04 

Date: Wed, 2 Jun 2004 17:49:55 -0500

Is there anyway to trace the actual query that is causing the problem in the
dmp logs? We have lots of queries running on the site -with most of them
being dynamically generated. Thoughts or is SQL trace our best option?

"Pat [MSFT]" <patfilot@online.microsoft.com> wrote in message
news:eMydiEGSEHA.2000@TK2MSFTNGP11.phx.gbl...
> It looks like the problem is that all of your ASP pages are waiting on SQL
> server. Basically, it looks like the query was created, a connection made
> and the query sent OK. It's just the receiving of the response. You
would
> need to check the SQL server to determine why it is not responding (bad
> queries?).
>
> Pat
>
> "David Trebacz" <trebacz@msn.com> wrote in message
> news:uExH2M$REHA.3016@TK2MSFTNGP10.phx.gbl...
> > Pat here are the IISstate logs for Inetinfo:
> >
> > Please help with the interpretation of the attached IISState files. Our
> > server is several times a day serving up 500 errors on what seems like
> > random pages. Every couple days IIS will also perform a restart. This
> > problem has just crept up on us over time. The majority of the code has
> been
> > in production for several years.
> >
> > "Pat [MSFT]" <patfilot@online.microsoft.com> wrote in message
> > news:Otuu6euQEHA.620@TK2MSFTNGP10.phx.gbl...
> > > Nothing here to point to a problem. There were 2 exceptions, neither
of
> > > them fatal, then the log was stopped. This is AD+, by the way, not
> > > IISState. You can get the latest IISState from
www.iisfaq.com/iisstate.
> > >
> > >
> > > Pat
> > >
> > >
> > > "David Trebacz" <trebacz@msn.com> wrote in message
> > > news:eKAIjUpQEHA.556@TK2MSFTNGP10.phx.gbl...
> > > > Help please interpeting our IISState file that was captured during
the
> > > > server being hung.
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
>
>

Relevant Pages
Loading