• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 10332
  • Last Modified:

SQLCLR high Wait Time in Activity Monitor

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).

Thanks,
H.
0
dnnhoster
Asked:
dnnhoster
1 Solution
 
udaya kumar laligondlaTechnical LeadCommented:
0
 
dnnhosterAuthor Commented:
Thank you, now I can rest more easy.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now