Re: large SP performance difference between identical servers

Bob Speaking wrote:

I have 2 sql server installed on 2 identical machines (same cpu, same disk and ram).
The first is the production database server and the second is for tests and development.

On development server there is one stored procedure that is extremely slower than the twin stored procedure on the other machine.
The table referred is the same, same data. (about 20000 records with 1 inner join).

I've checked out indexes (I've also rebuilt indexes) and sql server configuration but I don't find any differences.
Why one is faster than the second? (the "good" SP twin takes about 5 seconds to run..and the second takes about 1 minute)

Where I must focalize my attention? Where can be the problem?
(the development server is more "stressed"...I restore and backup database very often)

Perhaps the production server has the data already cached in RAM. Try
running the SP on the development server twice in a row - is the second
run a lot faster than the first?
.

Loading