large SP performance difference between identical servers
- From: "Bob Speaking" <pollazzone@xxxxxxxxxx>
- Date: Thu, 25 Jan 2007 23:56:07 +0100
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
.
- Follow-Ups:
- Re: large SP performance difference between identical servers
- From: Ed Murphy
- Re: large SP performance difference between identical servers
- Prev by Date: URGENT:SQL SERVER conveting date to integer
- Next by Date: Re: URGENT:SQL SERVER conveting date to integer
- Previous by thread: URGENT:SQL SERVER conveting date to integer
- Next by thread: Re: large SP performance difference between identical servers
- Index(es):
Relevant Pages
|
Loading
