Query Performance Problems  
Author Message
Shankley





PostPosted: Top

SQL Server Developer >> Query Performance Problems

Hi everyone, i have this query at work that im trying to run on our
development server. It never finished. I have even waited as much as 30
minutes for it to run but it never seems to complete. Why this is wierd, is
because if i run it on any server at work other than the development server
it takes about 3 minutes to complete. The development server has more memory
and faster processor than some of the other servers where it completes. They
are all running the same service pack (3). Here is what i development server
consist of
2xPentiumIII Xeon 900mhz
1gig ram.

I have tried everything try to improve perforamance including shrinking the
database and defragging the index, recompiling the procedure, clearing all
the procedure cache, rebooting the server. No matter what i can't seem to
get this procedure to finish. Its kind of hard to see why it isn't finishing
when i can get an actual execution plan. The "estimated" execution plan
looks just fine. The load on the server is very very low and i have checked
locking to see if that is a problem and it isn't. Does anyone have some
hints on what i can look at to see why this procedure isn't completing? Is
there any events i can look for in profiler or anything like that? Also,
when i run the procedure and i go look at the server...both processors are
pegged. any help would be appreciated.

thanks,
Brent

SQL Server236