My application connected to SQL 2005 Express edition DB which is installed on another machine in the network. Earlier connection to this db is very fast. But now when connecting to DB it will take more time to connect. The db connection time is around 15
seconds instead of 2 or 3 seconds. I use sqlclient connection. But the connection is too slow. And take more time to execute when I open tables via SSME in my machine. But when connecting from another machine, there is no delay in connection. How can I speed
up the execution time ?
Go to the complete details ...