Hey Folks.. I am back! 🙂

I didnt have the issue for few days and now it raises its ugly head again. I have the trace information below as suggested...

I didnt get the error today. It comes on a few days while it doesnt show its head on other. Also in an environment that has lesser number of processors,...

Oh ok..Let me put the trace on and monitor as you guys have pointed out. I will give you the results after I am done today. Thanks for keepin my...

I also tried viewing the graph from the profiler window, but of no avail! How do I know which all processes (as in user processes) that are running at the...

Gail, I have already done that. I have attached the Trace graph in my first post itself (as zip file). Could you look into it? All the object IDs in...

The select query is the victim!

Ok..let me put it down much more clearer of what I am dealing with. I know am dealing with a screwed set of databases but...

Thanks guys..really appreciate you helping me out here but could you dig deeper into your expertise and forsee something 🙂 Pleasssee...

I am not using any temp table or anything of...

How about slowly running queries? Would there be any problems caused due to memory paging or something of that sort? I did do the trace using profiler and have attached...