Hello, Here are my server options. I am using linked servers. Basically Server (B) gets the data from Primary server using synonms and stored into local perm temp tables ( they are not # tables). I have 4 physical processor box ( hyper threaded ). 10 GB ram, SQL 2005 64 bit. If I run a report on Primart server (A) it is completing in 3 min . Same exact report run from Server B 27 min. I know there will be some delay in data transfer not that much. Is there any parameters I can check? Both server parameters are same. only thing is they communicate thru linked server ( SQLCLNI-OLEDB) . Your help would be really appreciated .