Queries that run in 1 second take minutes on another server?

  • Thread starter Thread starter mat
  • Start date Start date
M

mat

I have a sql server db which runs on two different boxes, both with sql
server 2005 sp3. Some complex queries take minutes to complete on one
box and the other box completes them in a second. The backends are
identical copies and the queries are called from idential MS Access 2003
front ends. Access is local to the sql server boxes so no network
latency is involved.

The slow box is a virtual pc, os windows 2003 sp3, 2 gb ram.

The fast box is windows xp.

Both use the latest sql native client odbc driver from ms.

What kind of settings or factors might be responsible for the time
difference?
 
Haven't you answered your own question?

The slow box is the virtual box. Why does that surprise you?
 
Did you look at the execution plans on both servers?
Click to expand...
No...can I look at an execution plan if the query is based in Access?
I've never tried that, I'll see if it's possible. I will do an odbc
trace also.
 
No...can I look at an execution plan if the query is based in Access?

Of course, you can take the query from Access and run it manually in
Management Studio. If it is not easy to get at the underlying SQL then you
could use profiler to capture the actual query.
 
Of course, you can take the query from Access and run it manually in
Management Studio. If it is not easy to get at the underlying SQL then you
could use profiler to capture the actual query.
Click to expand...
Thanks Aaron I'll try the profiler.
 
Back
Top