I am trying to find out if one can profile managed triggers/procs as they execute within an SQL Server instance.
I use VS 2010 Ultimate and I also have JetBrains profiler here too, I am using SQL Server 2008 R2.
I'd like to cause a managed trigger to run say a hundred times and then get a feel for any hotspots, our managed triggers do some serious stuff, invoking remote systems over a network and all sorts, there is a lot going on and it would be nice to get a handle
on where this code is slowest.
View Complete Post