How Do I Fix Slow Connections To Remote Sql Windows Server 2008 R2

Question

1.00/5 (1 vote)

See more:

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.

Posted 25-Sep-14 3:47am

MashaJoey

Add a Solution

Comments

[no name] 25-Sep-14 9:51am

Get a better server, get a better network. Could be lots of things slowing your connection that do not have anything to do with your code.

ZurdoDev 25-Sep-14 11:33am

It could be anything. You'll have to troubleshoot your connection and your db.

2 solutions

Solution 2

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 ...

Posted 26-Sep-14 3:43am

MashaJoey

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

I will help you · Accepted Answer · 2014-09-25T04:14:00

Solution 1

Or check DB load by Activity Monitor[^]

Posted 25-Sep-14 4:14am

I will help you