March 10, 2008 at 4:03 pm
Hi All,
I'm new to the CLR arena, but I've noticed some funny activity that I am hoping someone maybe able to explain to me. I've read most of the forum posts I could find on CLR waitstates but couldn't find one that related to my question.
I am seeing large numbers of wait states for "CLR_Auto_Event" and "CLR_Manual_Event" on one of 8 SQL Servers. These waits have not been present previously and nothing has changed interms of SQL Settings, databases additions, and we don't run other applications on the SQL Server. I noticed the high count on the "Performance Dashboard" as the second highest waitstate behind SLEEP which dosen't seem to be of issue. Since we are running Dashboard Reports we are at SQL 2005 SP2.
I'm sure your all going, OK thats nice check your CLR code that is causing it. But the thing is we don't have CLR code and it is disabled on the server from executing. Here are the details I've collected along the way.
1. sp_configure and Surface Area Config shows CLR Integration disabled (0)
2. The CLR wait states continue to increment frequently throughout the day, and I've run a profiler trace without any CLR assemblies appearing.
3. select * from sys.dm_clr_properties shows:
directory C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\
version v2.0.50727
state CLR is initialized
4. select * from sys.dm_clr_loaded_assemblies shows:
no loaded assemblies
5. select * from sys.dm_clr_tasks shows:
0x00000001378B8080 0x000000008001C1D8 0x0000000000000000 E_TASK_ATTACHED_TO_CLR E_ABORT_NONE E_TYPE_USER 0 0
0x00000001672D0380 0x00000001244F01D8 0x0000000000000000 E_TASK_ATTACHED_TO_CLR E_ABORT_NONE E_TYPE_ADUNLOAD 0 0
0x000000014B55E120 0x000000012113A1D8 0x0000000000000000 E_TASK_ATTACHED_TO_CLR E_ABORT_NONE E_TYPE_FINALIZER 0 0
My question I guess is how can I have waitstates for CLR but the ability to execute it on the server is set to "disabled"
March 11, 2008 at 12:51 pm
Hi,
My DMVStats report also shows very high waits on CLR_Auto_Event & CLR_Manual_Event.
Pls check this out
It may clear out some of your questions.
March 11, 2008 at 1:02 pm
Jay Byoun (3/11/2008)
Hi,My DMVStats report also shows very high waits on CLR_Auto_Event & CLR_Manual_Event.
Pls check this out
It may clear out some of your questions.
Thanks for the link, but that blog says "If your using a SQL CLR application", in my case it is disabled and I am not running any CLR User code.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply