November 12, 2008 at 4:08 am
Hi guys,
i'm facing an issue :
I execute a simple query, select * from mytable, and it takes 3 secondes from my computer.
But when I execute this query on the server it takes less than a second.
What could be the problem?
Thank you,
regards.
November 12, 2008 at 6:44 am
Do you mean when you connect to a server from your machine the query takes longer than when you run it directly on the server? Data travelling across the network.
If you mean you have a database on your local machine and one on a server then it could be differences in processing power, memory size & speed, disk I/O differences, differing amounts of data... It's along list.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 12, 2008 at 6:57 am
yes I mean when I connect to a server from my machine the query takes longer than when I run it directly on the server.
I know the data travel across the network but it takes more than 6 times more, so it sounds a network issue?
thanks
November 12, 2008 at 7:37 am
It's also possible that you have different default ANSI settings on the two machines. This could affect performance. A good way to test both would be to use a trace (or Profiler), run the query from each location and see if there's a different there. If it's the same, the problem is probably in or around the network. If the performance is different, you'll want to look at what's different about each machine and it's connection to the database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 12, 2008 at 7:49 am
And please don't cross post! It just wastes people's time as they answer questions that have already been answered.
No more replies here please. http://www.sqlservercentral.com/Forums/Topic601230-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2008 at 8:05 am
Yes you're right, but I tried to delete the other post wihtout success. I'm sorry.
November 12, 2008 at 8:16 am
It's not possible to delete threads. You can either report it and ask the mod to delete it, or edit it and put a link in pointing at the correct thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply