Thanks! Will give it a try!

Lowell (6/5/2013)

---

Michelle-138172 (6/5/2013)

---

The main thing that puzzels me is why it only happens to web calling. There's never a problem running it in the Management...

The main thing that puzzels me is why it only happens to web calling. There's never a problem running it in the Management Studio. My web dev guys can't figure...

With Recompile didn't do anything.

No, none of that is happening. It happened both on my production and dev servers. There's nothing going on the dev when this happened. As soon as I dropped and...

Thanks for the advice! The thing is, all the tables involved in the proc are very static. The updates happen once a while and the proc usually works fine after...

Thanks for the input. It just occurred to me that a better option might be to dump all the data into a temp table which is a replica of table...

That sucks! With multiple instances on the same server, does the server automatically balance the resources across all instances or you have to carve out the memory and CPU usage...

Thanks again, Geoff. Is there a way to filter the database listing on Object Explorer in Mgmt Studio according to the access rights? I don't seem to be able to...

Very good point. Thanks a lot for the valuable input, Geoff.

One more thing, our regular SQL server 2008 is one instance shared among all the biz units. Is it advisable...

That makes a lot of sense. Thanks much, Geoff.

Regarding separating business unit by instance, I guess it applies to AS since I don't see a way to isolate...

Anyone, please?

I didn't mean to monitor the activities - just plain view the list of databases that belong to a certain user only. Say, there are 100 databases on the server,...

I have an...

Thanks for the update, Tom. That would be my plan as well to do the file check loop through SQL job if no quick fix can be found for SSIS....

I have almost same type of SSIS packages like yours. I have super high memory usage instead of CPU over time. But I think it's all because of the memory...