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
![]() |
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
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.
All times are GMT -7. The time now is 08:04 PM. |