Re: IISState File Help Needed

From: Pat [MSFT] (patfilot_at_online.microsoft.com)
Date: 06/03/04 

Date: Wed, 2 Jun 2004 21:20:32 -0700

Not from the .log files. There is from the .dmp files, but that is really
beyond the scope of the newsgroup. If you use IISState instead of AD+, it
will give you the page names which may tell you what queries are running.

PAt

"David Trebacz" <trebacz@msn.com> wrote in message
news:%23clrYRPSEHA.3056@TK2MSFTNGP11.phx.gbl...
> 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

  • Re: Audit Log
    ... > I wanted a query regarding archiving the data from the log files. ... > Server Enterprise Manager or Query Analyzer we can not have the log. ...
    (microsoft.public.sqlserver.security)
  • Re: Connection Throttle
    ... >I have an application that where some of the queries hit the server hard (I ... Some of the queries take 5 or more minutes to run ... usage is appropriate (log files on separate disk from data files) and ...
    (microsoft.public.sqlserver.server)
  • Can only run 2 windows at a time?
    ... I'm trying to monitor/tail ... some log files and perform queries to ... I can open two Internet Explorer windows and tail two files; ...
    (comp.lang.php)
  • Re: Importing XML for Newbies
    ... Why not just use an XQuery implementation to query them direct? ... I see no requirement here to involve a database at all. ... Create a DB for storing the log files? ...
    (microsoft.public.sqlserver.xml)
  • Re: Parse log files for data
    ... If it grabs the whole line that's ... I can easily remove the " query= " from the beginning of each ... Here's a sample entry from one of the log files (just the beginning of ... so I modified the regex accordingly to ...
    (comp.lang.perl.misc)