| Tibor Karaszi 2002-08-15, 7:23 am |
| Anders,
The two SQL Servers do not have the same database. By this I mean that there are differences
regarding indexes (index architecture differs between 6.5 and 7.0), different statistics etc.
Only way to have the very same database is by attaching or restoring the database.
So, you have to work with the query plan to see why the difference.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Anders Wåhlin" <anders.wahlin@erv.ericsson.se> wrote in message
news:ajg3bo$q6f$1@newstoo.ericsson.se...
> Hi!
>
> I have two SQL servers, one 6.5 and one 7.0.
>
> Both servers contains the same database. I've made a copy.
>
> When I run a query on the 6.5 server it takes 400 miliseconds for the rows
> to be fetched. If I run the same query on the 7.0 server it take 2 seconds!
> The query returns 1292 rows.
>
> The server that runs SQL Server 7.0 is more powerfull so this seems strange.
>
> Any ideas?
>
> Regards
>
> /Anders
>
>
>
|