I concur.. We should leave them ON unless we can prove that turning OFF will improve general performance...

Thanks for sharing your thoughts..

That's great...

Let me test it out...

Hi,

My DMVStats report also shows very high waits on CLR_Auto_Event & CLR_Manual_Event.

Pls check this out

http://blogs.msdn.com/psssql/archive/2008/02/05/high-waits-on-clr-manual-event-and-clr-auto-event.aspx.

It may clear out some of your questions.

Finally, the problem was solved and here's what I did.

1> Remove Oracle clients cleanly and then re-boot all cluster servers

2> Install Oracle client (10g) on the share drive (I do no...

I made some progress, the sql service account did not have the latest PATH for the new oracle client. this problem was fixed by rebooting server.

Now I'm getting different...

Did you solve this issue, dm_db_index_physical_stats is NOT getting the latest info ?

I'm having the same problems with sql 2005 sp1.