performance troubles..

I have 2 MS SQL Servers running on 2 machines that are identical. I am working with 2 databases - one from each machine. The structures of these databases are also identical however, the number of records are different.. SQL Server A has over 1.5 million records through which I am querying.. SQL Server B has roughly 100,000 records. I wrote a query on Server A that takes about 12 - 16 seconds to run. This same exact query takes over 30 MINUTES to complete on Server B - yes the one with less records by far. What could be causing a problem such as this?Thanks..ET

takizzle

Newbie Poster

1 post since Jun 2006

Reputation Points: 10

Solved Threads: 0

6 Years Ago

0

I am guessing you are missing an index or something. Without more information, hard to say for sure.

campkev

Posting Pro in Training

484 posts since Jul 2005

Reputation Points: 14

Solved Threads: 19

5 Years Ago

0

You might want to check that the indexes are the same on both databases. Don't remember which but when you do an import or copy indexes are not always transfered.

mwedberg

Newbie Poster

3 posts since Jun 2006

Reputation Points: 10

Solved Threads: 0

performance troubles..

This article has been dead for over three months