Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I use ANTS Profiler 4 to profile assemblies running in the SQL-CLR in SQL Server 2005 and 2008?

April 26, 2017ants Assemblies profile Profiler running SQL Server sql-clr

0

Posted

Can I use ANTS Profiler 4 to profile assemblies running in the SQL-CLR in SQL Server 2005 and 2008?

1 Answer

0

Posted

At present no. SQL Server 2005 and 2008 lock down the CLR pretty tightly to ensure that rogue .NET code can’t take down SQL Server. One of the things that’s locked out is the profiling API, and at the time of writing we haven’t found a way around this.