April 8, 2002 at 5:58 pm
We have two Identical (Hardware and software, except for slightly less memory in one server, and we've ruled that out) servers.
They have returned different times for a query. One takes 4 seconds the other 19 seconds. They have the same database, same data, same hardware, same versions, sub versions and service packs for SQL server.
Any ideas on how we can make the 19 second run in the same time as 4 second machine.
Thanks
Ian Wilkinson
April 8, 2002 at 7:00 pm
I'd start by verifying that the indexes for the tables involved match exactly and have been rebuilt on the server with the slower performance. Perhaps a better way would be to detach the db, copy over to the slow server, attach, then run the query - that way you're getting everything exactly as it is. That would help you rule out db issues and maybe point to the server itself or the network connection.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply