Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

0 views
Skip to first unread message

mat

unread,
May 16, 2009, 8:28:15 PM5/16/09
to
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?

Geoff Schaller

unread,
May 16, 2009, 9:17:36 PM5/16/09
to
Haven't you answered your own question?

The slow box is the virtual box. Why does that surprise you?

"mat" <m...@notarealdotcom.adr> wrote in message
news:MPG.2478f9f7b...@msnews.microsoft.com:

Aaron Bertrand [SQL Server MVP]

unread,
May 16, 2009, 9:24:04 PM5/16/09
to
Did you look at the execution plans on both servers?


On 5/16/09 8:28 PM, in article
MPG.2478f9f7b...@msnews.microsoft.com, "mat"

mat

unread,
May 16, 2009, 10:13:41 PM5/16/09
to
In article <C634DF74.2B98D%ten...@dnartreb.noraa>,
ten...@dnartreb.noraa says...
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.

Aaron Bertrand [SQL Server MVP]

unread,
May 16, 2009, 10:24:21 PM5/16/09
to
> 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.

mat

unread,
May 16, 2009, 10:34:32 PM5/16/09
to
In article <C634ED95.2B9DB%ten...@dnartreb.noraa>,
ten...@dnartreb.noraa says...
Thanks Aaron I'll try the profiler.

Manpreet Singh

unread,
May 18, 2009, 2:11:01 AM5/18/09
to
Update statistics and check for index fragmentation on both the server. Ones
both server seems identical in all respect then rerun the tests. If problem
still persist try using perfmon while executing queries on virtual machine

http://msdn.microsoft.com/en-us/library/ms186819.aspx

Manpreet Singh
http://crazysql.co.nr
MCITP – DB Admin, DB Dev SQL Server 2005
MCTS – MOSS 2007, SQL server 2005

0 new messages