Problem with a query plan of sp !!! 
Author Message
 Problem with a query plan of sp !!!

We use this query to obtain query plan for any sp without executing it.
It worked fine in ASE 11.9.2.x. But in 12.x we encountered a problem.
If sp contatins call of master..xp_cmdshell, server produces query plan
much slower than before.
We've made a special analyzer that works every sp out in such a way and
shows invalid plans.
But now we can't use it because, it looses connect when meets a sp with
a call of master..xp_cmdshell.

SET FMTONLY ON
SET SHOWPLAN ON
GO
exec up_proc
GO
SET FMTONLY OFF
SET SHOWPLAN OFF

CREATE PROCEDURE up_proc
AS
BEGIN
...

EXEC master..xp_cmdshell
...
END

--
My best regards,
Vitaly Lipovetsky.
Deputy head of IT division
First Ukrainian Intl bank

Brainbench(Tekmetrix) e-certification id 14050 SYBASE DBA 4.38
Brainbench(Tekmetrix) e-certification id 14050 MS SQL Server DBA 4.51



Tue, 21 Jan 2003 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SP Query Plan: have a look!!

2. Slow Query Plan Using SP

3. Working sp now results in Query Plan error

4. Different query plans for SP and the same SQL code

5. SP Query Plans

6. Why is Stored Proc plan slower than query plan

7. Execution plan,Query plan?

8. Locking Plan part of Query Plan?

9. Problems with bad query plans

10. Performance problem: Query Execution Plan

11. query plan problems...

12. Query Plan Problem


 
Powered by phpBB® Forum Software