guys! I have stored procedure, written on C# using Visual Studio 2010. It is running very slow and I want to profile it to detect slowness source. I have JetBrains dotTrace profiler and built-in Visual Studio profiler, but have no idea, how to attach any of these great tools to CLR stored procedure. Any suggestions, how it could be done? Thanks.
Maybe it would be useful for someone: you can profile CLR stored procedure, simply by creating executable that calls that procedure static method and profile this executable using one of existing profilers for .Net applications. I've used dotTrace.