July 6, 2009 at 12:13 pm
I am working with a customer that has a SQL Server 2008 instance and they are saying that the SQL CLR functions have been turned off (clr_enabled = 0) but they are still seeing lots of SQLCLR wait types.
I am also seeing the following entry in the log file when the server is restarted
Common language runtime (CLR) functionality initialized using CLR version v2.0.50727 from C:\Windows\Microsoft.NET\Framework64\v2.0.50727\
This is a 64 bit SQL Server 2008 cluster running on Windows 2008.
Is this a bug or is this expected behavior? Can someone shed some light onto what may be happening? If you need more information I will post it.
Thanks,
John
July 6, 2009 at 12:43 pm
Not sure as I am not using SQL Server 2008 (yet) and we currently aren't using SQLCLR, but it is possible that some of the internal processes may be using the SQLCLR.
July 8, 2009 at 6:31 pm
I have DL585 with win2k8+ sql2k8 64bit installed with default options...I dont see any entry for CLR in logs....though in
sp_configure returns...
clr enabled0111
Prakash
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
August 24, 2009 at 12:09 am
Some of the newer datatypes like the spatial ones (geography and such) are actually SLQCLR under the hood and the DB engine does not honor SQLCLR on/off for them because they are part of the system. I would start there..
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply