sqldba_newbie (12/28/2012)
I don't want to trace to run 24 X7 as i don't know when the issue would occur.
thats why i asked you to use trace when you are blank in any particular case use it but with PROPER AND REQUIRED filter. as we know that it s a resource intensive operation(that is what you would be thinking here and reluctant to use it ) , but when we have proper filer plus only fetching event which are relevant and required then you can minimize the resoure usage.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)