如何修复与远程Sql Windows Server 2008 R2的慢速连接 [英] How Do I Fix Slow Connections To Remote Sql Windows Server 2008 R2

问题描述

嘿所有......



i有一点问题...我通过互联网sql连接到远程计算机，我们使用windows server 2008 r2，任何方式我知道如何使用正常的sqlconnection cn连接到服务器......但由于某种原因，我与sql的连接速度很慢，而且每次都变慢...所以连接到托管sql的正确方法是什么？每次连接时，呼叫数据以及我与服务器的远程连接也变得越来越慢......我能做什么，谷歌让我失望



提前感谢。

Hey all ...

i have a little problem ... im connecting to a remote computers over the internet sql, we use windows server 2008 r2, any way i know how to connect to the server using the normal sqlconnection cn ... but for some reason my connection to the sql is slow and it gets slower every time ... so what is the correct way to connect to a hosted sql and call data and also my remote connection to the server is also getting slower with every connect ... what can i do, google has failed me

thanks in advance.

推荐答案

或者通过活动监视器 [ ^ ]

我有点得到它...我直接连接到sql，如果只是我肯定会有例外但是ñ ot正确...所以现在我使用wcf服务，我希望它能更好地工作......

i kinda got it ... i was connecting directly to the sql and if it was just me sure that would be exceptionable but not correct ... so now im using wcf service and i hope it will work better ...

这篇关于如何修复与远程Sql Windows Server 2008 R2的慢速连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！