| 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?
|
|
Thanks for the suggestion. The logs do not show me the actual web service requests - something that should be easy to do as its all XML. I think the IIS team needs to have a look at the SQL tools and get something similar to their profiler. I beleive IBM have created such a tool for their web service solutions.
|
|
magennisw@etrade.com.au wrote:
> 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?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/h tml/frlrfsystemwebservicesprotocolssoapextensionclasstopic.asp
(URL Wraps. Or use http://tinyurl.com/empf)
Just dress your method with a [Trace( FileName="here">)] attribute and the request + response will be saved to the file. This applies only to the Request or Response XML, not the HTTP headers.
HTH,
-- Deepak Shenoy http://shenoyatwork.blogspot.com
|
|
You could try developing a Web Service SoapExtension to log the SOAP messages for the problem method(s).
Simon. wrote in message news:1148801059.948445.245250@j73g2000cwa.googlegroups.com... > 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? >
|