1. set showplan on
test with 'set noexec on/off' (for statment) and 'set fmtonly on/off' (for stored procedure)
2. dbcc traceon(3604,302,310)
3. set statistics io on
http://www.webservertalk.com/archive87-2006-3-1422390.html
http://infocenter.sybase.com/help/topic/com.sybase.dc20022_1251/html/monitoring/X27349.htm
http://infocenter.sybase.com/help/topic/com.sybase.dc20023_1251/html/optimizer/X17067.htm
沒有留言:
張貼留言