SQLCLR high Wait Time in Activity Monitor
Posted on 2009-03-29
When I'm viewing my Resource Waits in the Activity Monitor GUI, in sql 2008. I see that the SQLCLR Wait Category has a very high Wait Time. In my case it's allways around 2003 (+/-2) ms/sec.
The other columns also have high numbers: Recent Wait Time: 2001, Average Waiter Count 2.0 and Cumulative Wait Time is approx 2328574 (when I'm writing this).
All other Wait Categories are very low, usually 0 or some single digit number.
What could be going on here?
What can I do to dig into this, and see what's going on?
Could anyone explain to me how I should be viewing here, what should I be expecting in this table (Resource Waits)?
BTW, I know that some assembly types where installed on the sql server for some geographic app use, and I can view them from the sys.assemply_types table. Could they somehow be involved?
Otherwize this is a pretty new and clean sql server (Sql 2008 - Web edition).