Execution Plan 
Author Message
 Execution Plan
Hi,

when I run a stored procedure in my system and in my
clients lap top,I have two different execution plan.

Why ? Can anybody help me out.



Sat, 28 Feb 2004 20:06:01 GMT
 Execution Plan

The plan is determined by lots of factors. Things like available memory, OS,
File Size, current statistics, # of Processors.....

--
Andrew J. Kelly,  SQL Server MVP
TargitInteractive

I proudly support the PASS SQL Server user community and its upcoming user
event,
 PASS 2001 North America. For details, visit <http://www.sqlpass.org>
www.sqlpass.org.)


Quote:
> Hi,

> when I run a stored procedure in my system and in my
> clients lap top,I have two different execution plan.

> Why ? Can anybody help me out.



Sat, 28 Feb 2004 20:19:52 GMT
 Execution Plan
Hi,

I am working on MS-Access ADP Project.In that I supposed
to have a report.
The record source for this report is a stored Procedure
(SP).
This Stored procedure is based on Many views and
joins.Ofcourse some of the
views gets data from another view.

This stored Proceudre takes about 50 secs to run with my
machine.
(Intel CPU,128Mb RAM,70 MB Database).
The same Procedure runs pretty good with my Client's lap
top.
(DELL Machine with 128 MB RAM).

I have tested the report by opening it up from the front
end (which
we have in MS Access,back end is SQL Server 2000 ).It
works fine.

But unfortunately when we deployed to client's server
2 * 400 Mhz CPUs (Dual Processors,1.13 GB RAM ),the stored
procedure
is not getting executed and showing up the report when
they test the report
part from the front end.Same time if they run the
SP seperatly in back end through query analyser it works
well.

All I wonder why it is not working with fornt end.As the
ACCESS ADP Reports directly
talks with backend,we need not to worry about time out
factors I guess.
even though,I have set 5 mins to OLE requests in the
advanced options of the ADP Project.

Since it is taking merely 30-50 secc to run,it shouldn't
go beyond 5mins.

can anybody help me.We are in the 11th hour of our
Projects.

Looking forward
Sundar



Sat, 28 Feb 2004 20:37:46 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Execution plan,Query plan?

2. How to Cache Execution Plans

3. mssql view execution plan underlying table change

4. execution plan

5. Understanding the estimate cost fields in the execution plan

6. Using Execution Plan

7. Performance problem: Query Execution Plan

8. I Got a different execution plan by using ADO

9. Known Execution Plan Bug?

10. QA: Wrong costs execution plan

11. Efficient reuse of execution plan using JDBC

12. Sql Server Query Analyzer Execution Plan


 
Powered by phpBB® Forum Software