Testing the web API services through sql profiler?

Question

I need help testing web api through sql profiler.

I tested with chrome advanced rest client and fiddler but i need to test with profiler, so I can know which method is really slow and i can insert different things in that

For example, if there are three thing in a method I can test by inserting one at a time; I can't do the same thing with fiddler or rest client service.

Thanks for Helping.

Answer 1

Wonderful question , i been searching for this and finally i found this link http://msdn.microsoft.com/en-us/magazine/cc163749.aspx It should help you out .One question , are you using locally or on the server.This matters for profiler

Answer 2

Just do EXEC sp_proc name , for all those 3 in your ssms , you should be able to see all the slowness and everything