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)

On Jan 26, 9:35 pm, Ed Murphy <emurph...@socal.rr.com> wrote:
> 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?- Hide quoted text -
>
> - Show quoted text -

"Bob Speaking" <pollazzone@tiscali.it> wrote in message
news:fAauh.23255$bH4.16317@tornado.fastwebnet.it...
> Hi at all,
> first post in this NG (i usually walk around .net programming ng :P )
>
> I've decided to write cause I have a strange (Strange for me.. I'm a
> beginner with sql server).
>
> well...too words....i go directly to question :
>
> 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)
>
> Thanks in advance,
> Bob
>