The SAO server is a AWS server..

Yes, data source has been updated, the report server has read permissions and it allows logins also..

We are facing the below error.:

The OLE DB provider "SQLNCLI10" for linked server indicates that either the object has no columns or the current user does not...

Yes, RPC in and out are true only. but problem still exists. We cant able to generate the report from colo to AWS server(Specific server).

Yes, we configured MSDTC server also, but still problem exists...

Thanks for the reply, the system is restarted by Application user.

Checked the event log also. But didnt find any related errors.

I got the above waittype using solarwinds tool....How to find the waits using SSMS? We are continuously facing performance issue in an production server??What all the possible reasons???

RAM:...

Thanks for the reply

One more thing, Some of the columns in the SP's are using full scan.. Whether that leads to memory pressure??

In our environment, we are experiencing slowness for calls against databases. what will be reason ..can anyone help on this...