Log in

View Full Version : Query Slows down with internet


Grammarian-Bot
Nov 24, 2006, 09:17 AM
When I am using internet and SQL Server 2000 at the same time, my queries run slowly. Why? Is there any way to fix this problem?
GB

Slogmeister
Jan 9, 2007, 12:47 PM
What exactly do you mean by "using internet"? Do you mean browsing? Is SQL running on your local machine, or are you running queries against a remote server? If you're running it locally, it takes a lot of cpu time and memory even when it's idle. If you're running queries against a remote server, well, then it's using the same bandwidth that you're using to browse the internet so they will naturally take longer. There isn't really a good way to "fix" the problem. You could get more memory or faster hardware if you're running it locally, but it will still chew up a lot of system resources. If you're using it remotely, you could get a faster network connection.