.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Are CLR waits benign?

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
I recently upgraded a vendor's database that included making (new) extensive use of CLR's to improve performance.  It apparantly worked...the user is thrilled.  However, this server hosts 40 other databases, so i watch it for the purpose of preventing server-level issues.  After the upgrade, i noticed for the first time ever, CLR waits being listed as the highest in wait time.  The next highest waittime is from "sleep" events.   I am getting this information from the "Waits" section of the free "Performance Dashboard" in SSMS.  This server is 2005 SP2 Enterprise.  It is the only server where i see any CLR waits.  Should i focus on this wait?  We also use a tool which reports on waits.  The tool did not report on this wait.  I asked why.  They answered that "CLR_MANUAL_EVENT and CLR_AUTO_EVENTs are internal waits that are considered ‘idle’ events" .So, is CLR wait event an item of concern?  Or, is it to be considered as a sleep event?Thanks for your time.Stevesteve

View Complete Post

More Related Resource Links

Data Collector - SQL Server Waits Report

In the Data Collector SQL Server Waits Report, in both the graph and table reports, there is a Wait Time measurement and it shows (ms/sec).  What exactly does that mean?  I see that it carries out to 3 digits, so does that mean it measures down to the millisecond?  Any help would be appreciated, I can't seem to find a definition.

Extremely high PAGEIOLATCH_SH waits but SQLIO result seems to be ok?


Hi There,

I tried to re-establish a db replication which was being test a while ago, everything was ok untill I noticed that when I run a queyr on the destination server, the performance is extremely bad and even not usable. a report query that takes 30sec on another server with similar specs will take 15min to finish!

I did a bit investigation and it revealed that the  PAGEIOLATCH_SH waits is the dominant waits time, this led me to run a sqlio test.

the result of random write and random read test result appears to be normal compared to the other server I mentioned above.

at this stage, I am kind of running out of idea, can anyone provide any suggestion?

just to clarify, the problem still exists even after I deleted the replication.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend