•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 455,985 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,789 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 979 | Replies: 1
 |
•
•
Join Date: Dec 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Slow SQL performance over internet We have a SQL server on a DL380 with 8GB of RAM and 2 processors. This should be enough to host a couple of databases.
When I'm on the same LAN as the server (on the outside of the firewall) a select * from [tablename] returning 12000 records takes less than 3 seconds. When I run the same query from a different location (connected over the internet) it take 43 seconds.
Moving the server to a different locaction and switching off the firewall makes no difference. Connecting to the server over a VPN connection is even a bit slower (45 secs).
Any idea what's happening here?
To summarize:
Query returning 12000 records:
- On same machine as the server < 1 sec
- On the same LAN 2 secs
- Just behind the firewall just over 3 secs
- Over the internet (port 1433) 43 seconds
- Over the internet (VPN tunnel) 45 seconds
When I'm on the same LAN as the server (on the outside of the firewall) a select * from [tablename] returning 12000 records takes less than 3 seconds. When I run the same query from a different location (connected over the internet) it take 43 seconds.
Moving the server to a different locaction and switching off the firewall makes no difference. Connecting to the server over a VPN connection is even a bit slower (45 secs).
Any idea what's happening here?
To summarize:
Query returning 12000 records:
- On same machine as the server < 1 sec
- On the same LAN 2 secs
- Just behind the firewall just over 3 secs
- Over the internet (port 1433) 43 seconds
- Over the internet (VPN tunnel) 45 seconds
Last edited by reneeklo : Dec 4th, 2007 at 11:15 am.
•
•
Join Date: Aug 2006
Location: Egypt
Posts: 763
Reputation:
Rep Power: 4
Solved Threads: 59
Master Poster
bandwidth problem, try to return fewer rows or in another meaning the most needed!! SQL Server not responsible for such lack in performance
B.Sc Computer Science, Helwan University
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
ajax apps banking bbc blog broadband business commerce crash developer development digg domain download exploits explorer finance firefox funds google graphics home ie 7 ie7 intel internet investments microsoft money mozilla network networking news office online phishing portfolio registration rss security server site software sql stocks terrorism vista web wiki windows
- Persistent spyware problems, HJT log included. (Viruses, Spyware and other Nasties)
- Microsoft .NET FAQ (ASP.NET)
Other Threads in the MS SQL Forum
- Previous Thread: select query
- Next Thread: Applying Constraints after creating a table.
