Solved

SQLCLR high Wait Time in Activity Monitor

Posted on 2009-03-29
2
8,910 Views
Last Modified: 2012-05-06
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
Comment
Question by:dnnhoster
2 Comments
 
LVL 12

Accepted Solution

by:
udayakumarlm earned 500 total points
ID: 24029716
0
 

Author Closing Comment

by:dnnhoster
ID: 31564012
Thank you, now I can rest more easy.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now