Re: large SP performance difference between identical servers
- From: "sriram" <sriram.ys@xxxxxxxxx>
- Date: 29 Jan 2007 20:42:09 -0800
On Jan 26, 9:35 pm, Ed Murphy <emurph...@xxxxxxxxxxxx> 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 -
Hi,
Maybe, you could do the following two things
1. running DBCC FREEPROCCACHE
2. running the proc with recompile
and i feel everything will be clear.
Regards,
Sriram
.
- References:
- large SP performance difference between identical servers
- From: Bob Speaking
- Re: large SP performance difference between identical servers
- From: Ed Murphy
- large SP performance difference between identical servers
- Prev by Date: Re: URGENT:SQL SERVER conveting date to integer
- Next by Date: Updating Partitioned View Across Linked Server
- Previous by thread: Re: large SP performance difference between identical servers
- Next by thread: basic web front-end tutorial
- Index(es):
Relevant Pages
|
Loading
