sybase执行计划

最新推荐文章于 2021-02-19 21:38:15 发布

weixin_33913377

最新推荐文章于 2021-02-19 21:38:15 发布

阅读量403

点赞数

文章标签： python

原文链接：https://my.oschina.net/u/138995/blog/214984

版权

2019独角兽企业重金招聘Python工程师标准>>>

set showplan on
go
exec sp_name
go
set showplan off

set showplan on
set noexec on
go

select .......

go

set showplan off
set noexec off

go

sp_showplan pid,null,null,null

---------------------------------------------------------
dbcc traceon(3604)
go
dbcc sqltext(spid)
go

---------------------------------------------------------
sp_showplan does not always work

---------------------------------------------------------
You can also get iwatch to sniff out sql statements from the network, iwatch is made by Exact Inc. it is an expensive software.
---------------------------------------------------------
If your ase server is 12.5x and above, you can get the sql statement out from master.dbo.monSysSQLText table. Check $SYBASE/$SYBASE_ASE/scripts/installmontables for details.

---------------------------------------------------------
if your ase version is older than 11.92, try dbcc pss(suid, spid)
To get the usage on dbcc command, try
dbcc traceon(3604)
go
dbcc help(dbcc command)
for example
dbcc help(pss)
go

转载于:https://my.oschina.net/u/138995/blog/214984