tracing web service calls

Our three tier web application is "pausing" under test loading (IIS 6.0
(win2003) -> Web services (win2003) -> SQL server) . The CPU usage on
the W3WP.exe on both the web server and middle tier drops to zero for
about 5 seconds then springs back into life. Nothing in the NT event
logs. No SQL database blocking.

I suspect it is a particular web service call. With SQL server I can
start a "trace" and get a list of all SQL calls (and their
parameters) and how long they are taking - this allows me to track
down "slow" SQL code. I can't see any tool that allows me to do
this for web service calls? Surly there is some IIS plug in that will
allow me to monitor this traffic?

.

Relevant Pages

  • Tracing Web service calls
    ... Our three tier web application is "pausing" under test loading (IIS 6.0 ... the W3WP.exe on both the web server and middle tier drops to zero for ... No SQL database blocking. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: My SQL 7 server was hacked through to store files onto. Please help
    ... Web Server? ... IIS version ... SA login being used for SQL ... Could he have hacked in through SQL? ...
    (microsoft.public.sqlserver.security)
  • Confused about SPNs
    ... Windows 2000 environment using three servers, SQL server, web server (IIS ...
    (comp.protocols.kerberos)
  • Re: Does SQL Server Compact 3.1 support multi connection?
    ... Just wanted to add a final note that, though it might be ok to run SQL CE ... All apps and web server, SQLCE 3.1 run on the same machine. ... But I'm meaning simultaneous multiple connections from apps and web ...
    (microsoft.public.sqlserver.ce)
  • Re: Does SQL Server Compact 3.1 support multi connection?
    ... It's the point that SQL CE not designed for the situation like a web server ... And we expect worst case is like 10 connections. ... But I'm meaning simultaneous multiple connections from apps and web ...
    (microsoft.public.sqlserver.ce)