March 10, 2008 at 1:49 pm
I have application who like to use HTTP Endpoints in our cosolidate enviornment. How I can measure the performance on HTTP Endpoints? I would like to know how much CPU, Memory and IO used by HTTP Endpoints?
Any suggestion? Thanks in advance.
March 13, 2008 at 5:06 am
I guess a simple answer is:
1) Create a Stored Procedure which returns a result-set similar to the application you use
2) Create an HTTP endpoint with a webmethod which points to the SP
3) Write a quickie .NET app to call the webmethod (if you don't know Visual Studio, just run through a wizard to create a new Web Service, and browse to the HTTP endpoint). [Of course, you could write a Web Service in any language you like]
4) Execute the SP 100 times (for example) from a Query Window and monitor MSSQL usage of CPU, memory, etc.
5) Execute the .NET app 100 times using a batch file and monitor.
It would be interesting if you published your findings in the forum...
Looking at the Performance counters provided by MSSQL, under "General Statistics" there are some counters for SOAP, for example "SOAP Method Invocations", which you could also monitor. But these few SOAP counters are the only counters I can find which are specifically for HTTP endpoints (Note: an HTTP endpoint always uses the SOAP payload).
Others might have better suggestions.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply