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 Performance Profiler 6 to profile assemblies running in the SQL-CLR in SQL Server 2005 and 2008?

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

0

0 Posted

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

1 Answer

0

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, unfortunately, at the time of writing, we haven’t found a way around this.