Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
monty
Posting Yak Master
130 Posts |
 Posted - 2011-09-28 : 00:33:49
|
| Hello,Need your pointers to fix below issue.We have a simple select statement if executed by logging on to the DB server takes about 1/10 of a second however if executed from a remote server is taking close to 10 seconds.We have checked below.1)n/w connections and data loss if any from remote server to db server2)cpu are 4 and RAM is of 16GB and the usage is optimal3)ran tracert please let me know if i can look at any other things which may resolve this issue.Regards,Montyits me monty |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-28 : 00:37:58
|
| how are you executing it in remote server? using opendatasource or with linked server connection?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2011-09-28 : 00:43:05
|
| Hi Visakh,from remote as well i executed the same select statement from SSMS below is the illustration in case i confused you.Case 1)DB server(Logging on to the db server)Select * from table-- executed in 1/10 secCase 1)Log on to a remote serverregister the db server in SSMSSelect * from table-- executed in 10 secI tried doing the same from few remote servers and the execution time is high i.e close to 10 sec.Regards,Montyits me monty |
|
|
|
|
|
|
Query execution slow when executed from Remote