Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Monitoring Extended SP use in Profiler.

Author  Topic 

aspeckman
Starting Member

10 Posts

Posted - 2008-09-30 : 17:51:02
Using Profiler, I set the ObjectType Filter to look for Stored Procs(8272) and Extended SPs(8280)

I have tried through code and Profiler to monitor Extended Stored Procedure use and have not had any luck. When I goto execute either documented or undocumented sprocs, XP_(DLL) or SP_(BuiltIn), the trace doesn't pic up any execution.

8272, regular sprocs get picked up by profiler, no trouble.

SQL Server 2005, latest patches(CUs) installed on fully updated Server 2003.

Help?

Al.
   

- Advertisement -