Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Tracing failed SP call Expand / Collapse
Author
Message
Posted Wednesday, May 15, 2013 6:21 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 1:40 PM
Points: 18, Visits: 63
Does anyone know if its possible to trace failed SP calls through Profiler? For example, if you call an SP without a required param, it red inks but nothing shows up in the trace to identify the failed proc call.

This would be helpful when debugging errors in a binaries data access.

Thanks in advance.
Post #1453299
Posted Wednesday, May 15, 2013 8:18 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 9:43 PM
Points: 298, Visits: 711
Hi,

I think SP:CacheMiss might help you. It is under Stored Procedures in the Events Selection tab. According to msdn this will : "The SP:CacheMiss event class indicates that the procedure is not found in the cache."

It's probably not built for your purpose but I think it might just work!


Regards,
Bevan Keighley
Post #1453303
Posted Thursday, May 16, 2013 7:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 1:40 PM
Points: 18, Visits: 63
Thanks! Just gave it a shot and I think it'll do.
Post #1453538
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse