April 20, 2012 at 3:05 am
Hi
Although I have seen clarifications on the difference between these 2 events, but I am still not very clear practically.
My purpose is to run a trace that captures procedure calls to 5 specific procs. The database proc calls come from a web application.These 5 procs might call each other inside proc definition.
Shall I use both events or jusr sp:completed?
My understading of RPC:Completed was that when a proc is called remotely from another server, then this event is fired. But I read somewhere that when a proc is called inside another proc, then this event is fired. Can someone pls elaborate?
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
April 20, 2012 at 11:23 am
S_Kumar_S (4/20/2012)
HiAlthough I have seen clarifications on the difference between these 2 events, but I am still not very clear practically.
My purpose is to run a trace that captures procedure calls to 5 specific procs. The database proc calls come from a web application.These 5 procs might call each other inside proc definition.
Shall I use both events or jusr sp:completed?
My understading of RPC:Completed was that when a proc is called remotely from another server, then this event is fired. But I read somewhere that when a proc is called inside another proc, then this event is fired. Can someone pls elaborate?
Because of bolded text above you want SP:Completed. RPC:Completed will only capture an outer proc call, and further to that, only when the web app is using an RPC call and not a standard SQL Batch to call the proc.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply